Fred --
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?)
>>Huh? How do I do that?
>>
>>>>How do I change the starting "Save As" folder for an Excel spreadsheet created using Automation? (I want to do so temporarily, not permanently). I do the following to get started:
>>>>
loExcel = Createobject("Excel.Application")
>>>>... but don't understand how I do "ChDir".
>>>>
>>>>Thanks in advance,
>>>
>>>Why not just specify the full path?
>
>Specify the fullpath name in the SaveAs:
>
>
oX.ActiveWorkbook.SaveAs(cFolder+cExcelFileName)
Jim Nelson
Newbury Park, CA