Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding to copy sheets into a new workbook
I'm coding a macro and want it to copy existing sheets as an array into a new
workbook, then I want to edit the copied sheets in the new workbook. I'm having trouble with the code, I've got the below, but don't know how to activate the new workbook for editting. Sheets(Array("Summary", "Pace", "Topline Media", "Media Detail", "Creative Trending", "Creative Detail", "Creative Opt", "CTD", "Formula Definitions")).Copy Windows(MacroFileName).Activate |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA coding to copy sheets into a new workbook
have a look he
http://www.rondebruin.nl/tips.htm Corey.... "gitlin" wrote in message ... I'm coding a macro and want it to copy existing sheets as an array into a new workbook, then I want to edit the copied sheets in the new workbook. I'm having trouble with the code, I've got the below, but don't know how to activate the new workbook for editting. Sheets(Array("Summary", "Pace", "Topline Media", "Media Detail", "Creative Trending", "Creative Detail", "Creative Opt", "CTD", "Formula Definitions")).Copy Windows(MacroFileName).Activate |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy all sheets to a new workbook | Setting up and Configuration of Excel | |||
Copy several sheets from one workbook into another at the same tim | Excel Discussion (Misc queries) | |||
copy workbook sheets? | Setting up and Configuration of Excel | |||
Copy 1-4 sheets to a new workbook | Excel Programming | |||
Copy select sheets to another Workbook | Excel Programming |