VBA coding to copy sheets into a new workbook

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste sheets to new workbook 14
Copy two sheets from workbook & create new workbook 8
Copy worksheet, trying to paste to new workbook error assistance. 1
Select specific sheets and copy to new workbook 2
Copy sheets to New Workbook - Excel 2007 1
Macro to copy sheets to another workbook fails after about 45 copi 3
copy tabs into new workbook, save, and close. 2
Sheets to new WorkBook 4

Top