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
Bookmarks