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