Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel binary file 2007?
Message
From
11/04/2011 09:30:46
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Excel binary file 2007?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Miscellaneous
Thread ID:
01506899
Message ID:
01506899
Views:
93
Hi friends:

A client of mine is worried because many of his clients asks for mail about his prices. I asked me if it is possible to send them a mail with the information.

I said "I'm going to think about it"

I sat down here and I programmed a "simple" program that creates a MS Excel file to attach with a mail. Everything was right but in other client I had the problem the CONSTANTS of Excel 2010 are not the same with 2007 (I love Microsoft) so I decided "saveas(nfile)" instead of "saveas(nfile,nconstant)" (I'd like a 2003 Excel file XLS)

Well. I installed the program, I ran it. Guess what? When I try to attach the XLS file it doesn't exists.

I search it and I find it where I expect but it is a.. ¡Binary 2007 Excel file!!!

How is it possible? My client hasn't lights enough to select "binary excel book" as default.

I looked for the Excel version of my client and it is 2003! not 2007 And obviously saves files as default (XLS)

Does anyone know a way for "saveas" which can be predictable in 2003, 2007 and 2010 Excel version?

I must say a year ago or so I bought a e-book because an advise here about "Office automation" but didn't help for this. Also in many questions says the damm explanation: "If you want to know more about it see the MS Offfice help"...

Thank you

Hector
Next
Reply
Map
View

Click here to load this message in the networking platform