Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBS script to copy excel sheets into new excel file
@combo Thanks for your help. Note that the Before and After syntax will not work in a .vbs script execution as I would be calling it from a command line but that order of the sheets doesn't matter too much. I was able to use your suggestion on the wkbkt_to.worksheets(1) to have it work. Thanks... -
VBS script to copy excel sheets into new excel file
I am trying this code .vbs but am getting an error of "Copy Method of Class Worksheet failed". Existing File1 has two sheets called "Test1" and "Test 2" while File2 has two sheets called "Test3" and "Test4". However generically the number of sheets may be different with different names and it...
