LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 63
Default Automatically Saving created FILE

Morning macronewbie


"macronewbie" wrote in message
...

I want to "save as" the generated new workbook automatically when I click
the command button to create the new wokbook. Is this possible? THANKS!


Not sure if you want to be able to choose a path and filename. This is a
simpler version:

ActiveSheet.SaveAs Filename:="c:\Temp\CSVfile.xls"



 
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
BACKUP file created when saving Excel Workbook with VBA Matthew Scheperle Excel Programming 0 February 16th 10 05:04 PM
open a file automatically which was created yesterday davethewelder Excel Discussion (Misc queries) 8 March 7th 08 11:52 AM
Saving a file to have the filename of the dated it was created Dave[_65_] Excel Programming 1 May 17th 06 10:42 AM
Saving multi-tab excel file created from comma delimited text file Marcus Aurelius Excel Programming 2 December 19th 05 05:16 PM
FILES CREATED AUTOMATICALLY WHILE SAVING Venoy Varghese P Excel Discussion (Misc queries) 0 March 30th 05 04:01 PM


All times are GMT +1. The time now is 05:04 AM.

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"