Runtime error 9: Subscript out of range

Hi Guys & Gals,
Im having a shocker with the code below, it works on some pc's on my company network but not all. Basically i am trying to copy data from one opened spreadsheet and paste it into a master document. I have confirmed that all spreadsheets are opened in the same instance of excel (by using file/open). Everyone is on the same version of Excel, 2007. The people that it doesnt work for are in a different office location, but we're all on the same network. Ive read every solution on this error that i can find, but have never been able to solve it (for months now we've been getting people whos pc it runs on to run the macro for us)..
Any ideas? the debugger shows the code breaking on

Please Login or Register  to view this content.

Many thanks in advance!
Dave

Please Login or Register  to view this content.

The line

Please Login or Register  to view this content.

assumes you have opened this workbook but I see no code in your macro checking that this file is opened and if not opens the file before trying to activating it.

Alf

Thanks Alf, Yea i have definitely opened that workbook,infact the macro runs from within this workbook

Yea i have definitely opened that workbook

Strange as the most obvious reason for a runtime error 9 is that excel can't find the workbook. Perhaps you could test using the index value for those who do get the runtime error 9.

Excel assigns index values to workbooks as you open them. The first workbook opened has an index value of 1, the second workbook opened has an index value of 2, and so on.

So if "performance uploader v11.0.xlsm" is the first workbook to be opened then

Please Login or Register  to view this content.

should activate "performance uploader v11.0.xlsm".

I would suggest you only use the index method for testing as this is an "unstable" method for activating workbooks i.e. close the 1st workbook and the previous second workbook now becomes the first workbook.

Alf

Thanks Alf ill give it a go and revert back!

No Luck with indexing im afraid Alf, Anybody any other ideas, anybody? it seems to have everyone i ask stumped, all i can come up with is that its something to do with the network set up... the only problem i have with that is when i connect my laptop to the same network it works fine (remembering we have people in 2 locations, the one thats failing is a regional location, i have gone there with my laptop though and it worked fine)

Thanks Robert, yes i have confirmed the same instance by using excels "file/open" to open the files, its a real stumper!