Copy Multiple Spreadsheets into One Workbook

  • Thread starter Thread starter Astroplastic
  • Start date Start date
A

Astroplastic

I'm having problems with the proper coding notation for the .Copy Sub.
i want to run this via VBScripting or windows scripting but don't
know what to substitute for the ":="

Does anyone know how this would translate into a VBScript?


XL.Application.Workbooks(1).Worksheets(1).Copy After:=Worksheets(i)

thnks

bryan
 
Tried it. Get the same error as before: "Copy method of worksheet
class failed."

I'm assuming this is due to said syntax. If this is the case, I have
yet to see a working example in WSH/VBS in the groups. Perhaps i'm
going about it the wrong way?
 
Back
Top