Jake02
10-06-2007, 05:30 PM
I'm new to VB, and I was given a program written in VBA within Excel to modify for a new situation. My only (apparent) obstacle is with anything that starts Workbooks. , such as
Workbooks("BUILDQUIRIES.xls").Activate
I keep getting a run-time error '9' stating that "subscript is out of range" or run-time error '1004' that your file "could not be found."
Can someone PLEASE help me?!?
Workbooks("BUILDQUIRIES.xls").Activate
I keep getting a run-time error '9' stating that "subscript is out of range" or run-time error '1004' that your file "could not be found."
Can someone PLEASE help me?!?