>>Hi Yuri,
>>
>>I was thinking about it as well.
>>
>>Alternatively, do you know how to call Excel.SaveAs dialog interactively?
>
>Usually you need something like:
>
>oExcel.Application.Dialogs(DialogNumber).Show
>
>You can go to Excel VBA help to find out what is exact number for SAveAs dialog
Thanks, I was able to go to VBA Help eventually. Based on the examples in the reference
Application.Dialogs(xlDialogOpen).Show
I would assume it's
#DEFINE xlDialogSaveAs 5
oExcel.Application.Dialogs(xlDialogSaveAs).Show
If it's not broken, fix it until it is.
My Blog