>>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?
If it's not broken, fix it until it is.
My Blog