PDA

View Full Version : Solved: Save As dialog help.......please!



sconly
04-13-2010, 07:46 AM
How do you set the 'Save in:' location/folder setting in the Save as dialog box, through vba?

Thanks.

Bob Phillips
04-13-2010, 07:55 AM
ChDrive "C:"
ChDir "C:\test"
ActiveWorkbook.SaveAs ....

mdmackillop
04-13-2010, 10:33 AM
for the dialog box

ChDir "C:\temp"
Application.Dialogs(xlDialogSaveAs).Show