macro save as and choose folder in spec path

[kniaza]

Hi,everybody!

Can you help me please with macro?

I want to create a macro which can open the "save as" dialog window in specified path and then I can choose folder in this path to save my file as. In other words user run macro and it open the specified path and then he save his file in his folder in this path

Now my vba knowledge let me only to create macro which save file in specified folder like this:

ChDir "C:\Documents and Settings\user\Desktop\reports"
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\user\Desktop\report\report dd mm - dd mm.xls" _
, FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

 

[p45cal]

check out
Application.Dialogs(xlDialogSaveAs).Show
It can take arguments:
Search for:
Built-In Dialog Box Argument Lists
in Excel help.
Also Googling for:
Excel xlDialogSaveAs
gives plenty of food for thought.

 

[kniaza]

big thanks! I'll try this.