Where would you like to save - Name?

[ianripping]

I have this code:-

Name = InputBox("What would you like to save the as?")
ActiveWorkbook.SaveAs (Name)


When I run this, it will save the file in the current workin
directory.

I want a promt to come up asking where it would like to be saved, bu
in doing this it is like the windoes explorer that you get when yo
manual click File > Save As, so you can choose which directoy you woul
like, any idea's

 

[Papou]

Hi
Use Application.Dialogs, this will allow both operations:
MyName = Application.Dialogs(xlDialogSaveAs).Show
If MyName = False Then MsgBox "You cancelled the Save operation",
vbInformation, "Cancelled"

Regards
Pascal

 

[ianripping]

Thanks this works a dream