How do I get around this?

"witek" wrote in message
...
Anthony wrote:
Hi,

The problem I am having is only occurring on 2 pc's. I have run the
code on numerous other machines with no issues, but the annoying thing is
I need it to run it on one of the pc's that is having the subscript out
of range error.

I have attached the two spreadsheets. The master file is meant to open up
the office file and load in any information. The code is written so the
user can select multiple files and it will work its way through them.

The code is not very fancy but it was something I was putting together in
a hurry and I was going to go back through the code and clean it up etc.

What I don't understand is on the machines it failed on, the code in
module 2 (Button2_click) fails during the function; e.g (sample of what I
have descriped)


fname="Tracker file"
Workbooks.open(fname) 'ok
Workbooks(fname).sheets("sheet1").select 'fails - subscript out of
range

Any help would be gratefully received.

I apologise for having to attach files.

Anthony

p.s password is dragon1



different regional setting and "sheet1" is not "sheet1" ?