View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Astroplastic Astroplastic is offline
external usenet poster
 
Posts: 2
Default Copy Multiple Spreadsheets into One Workbook

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