Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file as a new file
Hi!!
When i click on my command buttom i would like to save the file i'm working in to a new file, the file name come's from a variable. "filename" Can some one help me? Best regards alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save file as a new file
activeworkbook.saveas filename:=myFilename, fileformat:=xlworkbooknormal
(I wouldn't use a variable with the name Filename. Filename is used for lots of parameters within VBA.) There's another command that you may want: activeworkbook.savecopyas (see VBA's help for more info.) Alvin Hansen wrote: Hi!! When i click on my command buttom i would like to save the file i'm working in to a new file, the file name come's from a variable. "filename" Can some one help me? Best regards alvin -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excell2003 (SP-1) File > Save and File > Save As.. grayed out | Excel Discussion (Misc queries) | |||
Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
Excel marcos firing on file save as but not file save | Excel Programming | |||
Save File to Another Directory, but not change Users File Save location | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |