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)
Paul A. Busbey
Victoria Insurance