>>>Hi friends:
>>>
>>>I add an Excel object and everything works well but I'd like to allow my client to "save as" with a suggested name.
>>>
>>>I tried oExcel.workbook.save("My name") and an error "Invalid number of parameters" or so.
>>>
>>>I tried oExcel.workbook.saveas("My Name") and an Excel file is saved as "My Name" but I want the user to be able to change it.
>>>
>>>Can anyone dissipate the haze of my ignorance?
>>>
>>>Thank you
>>>
>>> Héctor
>>
>>Héctor,
>>
>>You can prompt user to enter the file name in, say, text box, and then use textbox.value in .workbook.saveas(...) statement.
>>
>>Good Luck
>
>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