Hi,

Need expert advice he How can I change the default file path
appearing in the Save-As dialog box using VBA? I have a workbook
application stored at, say, C:\MyProgram, I want the user save their
file automatically at a different location, say, c:\my document,when
they click Save or Save As

Thanks much in advance.