Ed --
I saw that as well. Unfortunately, it appears to do so permanently. I want it to happen just for the current session.
Jim
>>Charles --
>>
>>I understand how that would work. However, I don't want to save the file ... all I want to do is to change the directory that the file would be saved in if the user decided to save it. (I make the Excel file visible so that the user can modify and/or save as needed)
>>
>>>I simply provide the user a dialog for them to specify a path or file name and store that to a variable and use it as apporpriate in the saveas command.
>
>James,
>I just tried this...
>
>oe=CREATEOBJECT("Excel.application")
>?oe.DefaultFilePath
>* shows c:\excel\files
>oe.DefaultFilePath="c:\excel"
>?oe.DefaultFilePath
>* shows c:\excel\
>
>
>It seems to change the Excel default file location for Excel 2000.
>
>Ed
Jim Nelson
Newbury Park, CA