Hello -


I am needing a script in Excel that I can press a button and it will ask for a folder name, then read through all the XLS files in the folder one by one and step through the individual tabs writing a segment from each tab to another spreadsheet



For example: I have 123.XLS, 456.XLS and 789.XLS all in one folder

123.XLS

Sheet1

Sheet2

Sheet3

456.XLS

SheetA

SheetB

789.XLS

SheetX

SheetY

SheetZ



MACRO/Script would reside in ABC.XLS in another folder so it is not read.



I would like this script to first open 123.XLS, finding it has 3 sheets. I would for example to read A1 and place it back into ABC.XLS, then go to sheet2 and read A1 and place it back into ABC.XLS, then sheet3 and read A1 and place it back into ABC.XLS



Then go to the next XLS file.



I hope this makes sense.



thanks.