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