Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the ActiveWorkbook.SaveAs command to save a file from a template
to an individual Excel file for each of 31 items. The code selects the worksheet and copies it to a new workbook, then saves the new workbook with a set name. The code is all working correctly but when I try to open the file I am getting the Disable/Enable macro question. I don't want the end user to see this message (or the macro) and there is no reason for the macro to save to the individual file but I can't get it to stop. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro path follows the "SaveAs" file | Excel Programming | |||
macro for copying file | Excel Discussion (Misc queries) | |||
SaveAs macro: How do I specify "Replace existing file?" | Excel Programming | |||
Overwriting a file automatically using saveas in a macro | Excel Programming | |||
SaveAs without copying Macro | Excel Programming |