LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default SaveAs Copying Macro to New File

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro path follows the "SaveAs" file OlieH Excel Programming 1 March 3rd 07 01:50 AM
macro for copying file Joseph Excel Discussion (Misc queries) 1 August 24th 05 02:07 PM
SaveAs macro: How do I specify "Replace existing file?" [email protected] Excel Programming 1 May 24th 05 02:36 AM
Overwriting a file automatically using saveas in a macro Sam Excel Programming 5 May 5th 04 04:01 AM
SaveAs without copying Macro Martijnhj Excel Programming 5 February 27th 04 01:38 AM


All times are GMT +1. The time now is 02:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"