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" ?