General information
Category:
COM/DCOM and OLE Automation
>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only