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?
Jim Nelson
Newbury Park, CA