Thread: Error when refering to a closed file

Hello,

I am running a macro which refers to a file on a different drive.

If I run the macro with the file not opened, I get an error. However, if I get the macro to open the file, and then execute the code - it runs as expected.

The code I am trying to run is :-

With myBook.Sheets("Sheet1")
Set RngM = .Range(.Range("B2"), .Range("B" & Rows.Count).End(xlUp))
End With

Can someone confirm if a file has to be open in this type of instance.

Thanks

Originally Posted by teylyn

Hard to tell, since from your code it's not obvious that you are referencing another file.

Just live with the fact that some stuff only works when the other file is open.

Sorry, but is that a yes or a no.

I am refering to the file in the fist line of the code (mybook)

I'd rather have the correct answer in this instance as I'd prefer not to open the file if it isnt required.