>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)