It actually saves the spreadsheet. I've never looked at a running instance of Excel to see if it leaves that as the default for the next save, I don't have any user interaction with the spreadsheets, it's 100% automated, Excel isn't visible.
>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)