Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to save Excel Worksheet?
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:
56
>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

Click here to load this message in the networking platform