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

--
Message posted from http://www.ExcelForum.com

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 " a écrit dans le
message de ...
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 working
directory.

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


---
Message posted from http://www.ExcelForum.com/