Hi All,

My query is this.

I have an excel file (datalogs.xls) that is saved on the local drive of multiple devices (60 test stations) on a workgroup. I need to copy the value in sheet1 A1 and Sheet 2 A1 of the excel files to an excel file on my PC.

There is a workbook that does this but each path had to be inputted and log in credentials inputted. When this workbook was transferred to another pc it did not work.

What I need is a script that will automatically input the workgroup credentials [The work group devices all have the same username (testfloor) and password (lah)], copy the values in sheet1 A1 and Sheet 2 A1 of the excel files and paste them to new excel file.

Is this possible?.

thanks in Advance.

Rgds,

M