Error when refering to a closed file

[bd528]

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 :-

Please Login or Register  to view this content.

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

Thanks

[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.

[bd528]

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.