Message
 
To
10/03/2010 09:39:03
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01453718
Message ID:
01453727
Views:
59
>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
Previous
Next
Reply
Map
View