>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
oe.DefaultFilePath="c:\excel"
?oe.DefaultFilePath
It seems to change the Excel default file location for Excel 2000.
Ed