How do you set the 'Save in:' location/folder setting in the Save as dialog box, through vba?
Thanks.
How do you set the 'Save in:' location/folder setting in the Save as dialog box, through vba?
Thanks.
[vba]
ChDrive "C:"
ChDir "C:\test"
ActiveWorkbook.SaveAs ....
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
for the dialog box
[VBA]
ChDir "C:\temp"
Application.Dialogs(xlDialogSaveAs).Show
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'