Subscript Out of Range

[PrizeGotti]

Hi all,

I'm a little bit baffled by this one, I'm trying to use the following line in my code;

Please Login or Register  to view this content.

However where I try to use it, whether it be a variable or directly into the code, I get "Subscript Out Of Range".

Any idea why this won't work?

Heres my full macro so you can see how I am using it.

Please Login or Register  to view this content.

Many thanks!

[CheeseSandwich]

Has the workbook you are running the code from been saved to a folder location?

Is the workbook you are defining already open?

[PrizeGotti]

Hi CheeseSandwich,

Yes both workbooks are saved to the same folder. But to answer your second question, no, I need to have this working while not have the other workbook open. And I'm guessing thats why I'm going wrong.

I need to extract data from the other workbook whether its open or not. Is this possible?

[CheeseSandwich]

Are the below sheets that are inside the SrcSheet or are they just in the file you are running the code from?

Please Login or Register  to view this content.

[rorya]

You do not include the path when referring to an object in the Workbooks collection.

[CheeseSandwich]

I think i can see that they are not part of SrcSheet, maybe the below will help - i have opened the file.

Please Login or Register  to view this content.

[PrizeGotti]

I think i can see that they are not part of SrcSheet, maybe the below will help - i have opened the file.

Please Login or Register  to view this content.

This seems to be what I was looking for, my only concern being that it still requires the other workbook to be opened. Unfortunately I have no control whether the "Client" workbook will already be open by another user or not. If another user has the workbook open, will this cause an error?

[CheeseSandwich]

It should just open a read only copy as it would if you opened the file while someone else was in it manually.

You can change the open line to the below if you always want to open the file read only:

Please Login or Register  to view this content.

[PrizeGotti]

You are a legend and a scholar. Many thanks!