| 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 |
| 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 | |||
Hybrid Mode
