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
|