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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.