Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to save Excel Worksheet?
Message
 
 
To
10/03/2010 11:08: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:
01453886
Views:
62
What stops you from getting what you want?
llSaved = oExcel.Dialogs(xlDialogSaveAs).Show(lcNewFileName)
You can also specify a format to save as the second parameter.

>
>I thank you very much but I got the same with "oexcel.save()" or "saveas()"
>
>The result is "Libro1..2..3...4..." an so (the Spanish default name for Excel) and that's not what I want.
>
>I want that dialog box but instead of "Libro1" : "Sales notes on February 2010" and if the client doesn't want that name for the file He is able to change it.
>
>I think I will use the suggestion:
>
>"You can prompt user to enter the file name in, say, text box, and then use textbox.value in .workbook.saveas(...) statement"
>
>This was not what I wanted to do but You can't do everything you want...
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform