Because I divided many large xls workbooks (single worksheet only) into multiple worksheets, each worksheet (after being separately saved) has a unique name, not the standard "Sheet1."
Another program I'm using (SAS) is expecting each worksheet name to be "Sheet1."
I can, of course, manually go into each of the workbooks and rename the worksheet back to "Sheet1."
Would be lots easier, though, to have a batch file, vbs code, ahk code, or something, to place in respective folder, double-click, and do the name-change automatically.
In present case all the workbooks (in different folders) have the same name: data.xls
Only one worksheet per workbook, worksheets have various names (like 15-1, 17-3, etc.).
Would someone please write the code that changes first worksheet (and only) in a workbook to "Sheet1"?
Note: If it would be necessary to edit code to put the name of existing worksheet, then never mind. That would be just as much work as manually renaming worksheets.
Any thoughts appreciated.