Paul --
Not sure now to use the "FileDialog" object.
DefaultFilePath, from what I can tell, sets the default file path for next workbook opened. However, it's a permanent setting, unfortunately.
I don't want to use the "saveas" method, because I don't want to save it, I just want to provide the path that will be used should the user decide to save it. (I'm exporting a grid to Excel, which they can modify and save if desired.)
Thanks,
Jim
>I've never actually used these objects before, but going through Excel's VBA editor, I see this FileDialog object that has DialogType and initialFileName properties. It looks like that MIGHT be useful to you. The Excel application object itself has a DefaultFilePath property, but I'm not sure if that would help you in this situation.
>
>Alternately, is it possible in your app for you to use Fox's putfile() to get the desired save location & then issue this workbook.saveas() to automatically write to the desired location?
>
>>OK, back to my original question. How do I set the path that the Excel file will be saved in
if the user decides to save the file? (Of course, the user could override this by doing "Save As" on their own.)
>>
>>>Yes it does save the spreadsheet under specified full name.
>>>
>>>>
>>>>One last question. Does that actually save the spreadsheet? Or does it just set the full path for the name that it will be saved as if the user later decides to save it? (OK, that was really two questions, wan't it?)
>>>
>>>>>Specify the fullpath name in the SaveAs:
>>>>>
>>>>>
oX.ActiveWorkbook.SaveAs(cFolder+cExcelFileName)
Jim Nelson
Newbury Park, CA