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