Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy macro to a new book in 2007
Hi lwidjaya
See http://www.rondebruin.nl/saveas.htm I use ActiveSheet.Copy But you can also use this to copy more sheets Sheets(Array("Sheet1", "Sheet3")).Copy -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "lwidjaya" wrote in message ... I have a master file with a macro in it. When I click a button, the macro will copy 3 sheets from the master file to a new book. I have macros in 2 of the sheets that I copy. It works fine (meaning the macros are copied over to the new book also) until the macro runs the saveas function: ActiveWorkbook.SaveCopyAs "C:\New\" & NewName & ".xls" The new file doesn't have any macro in it. I tried saving the new file as .xlsm and .xlsx but Excel doesn't recognize the file extensions when I open the new file. What should I do to keep the macro in the new file? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
copy 2007 created macro to run in 2003 | Excel Discussion (Misc queries) | |||
macro: copy multiple workbooks to multiple tabs in single book | Excel Programming | |||
macro to copy specific rows to a new book | Excel Programming | |||
copy from one book to another | Excel Programming |