Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two problems with DBF to Excel function
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01373048
Message ID:
01373120
Views:
30
This message has been marked as a message which has helped to the initial question of the thread.
Hi Naomi
I might be able to answer you second question, I use the following code to detect Excel 2007 and save the file without alerts:

xl.DisplayAlerts = .F.
if '12' $ xl.version && XL 2007
xl.ActiveWorkbook.SaveAs(this.xlFilename,39)
else
xl.ActiveWorkbook.SaveAs(this.xlFilename)
endif


Hope this helps
Kevin
Kevin Delaney
Financial Systems Manager
CPL Solutions Ltd

83 Merrion Square, Dublin 2, Ireland.
e: kevin.delaney@cpl.ie w: www.cpl.ie
p: +353 1 482-5368
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform