Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Multiple Spreadsheets into One Workbook
Tried it. Get the same error as befo "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? "Patrick Molloy" wrote in message ... try XL.Application.Workbooks(1).Worksheets(1).Copy After:=XL.Application.Workbooks(1).Worksheets(i) -- Patrick Molloy Microsoft Excel MVP ---------------------------------- "Astroplastic" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combine multiple spreadsheets into one workbook | Excel Worksheet Functions | |||
Copy the same 2 columns from multiple spreadsheets into one new sh | Excel Discussion (Misc queries) | |||
password protect multiple spreadsheets in a workbook | Excel Worksheet Functions | |||
Consolidate multiple spreadsheets into a single workbook | Excel Discussion (Misc queries) | |||
Workbook & multiple spreadsheets | Excel Worksheet Functions |