Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Two problems with DBF to Excel function
Message
From
15/01/2009 05:03:02
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
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:
01373945
Views:
29
This message has been marked as the solution to the initial question of the thread.
>>2) I don't have 2007 here but this should work:
>>
>>
oExcel.ActiveWorkbook.Close(0)
>>oExcel.ActiveWorkbook.Saved = .t. && just thi sline should be enough
>>
>>Cetin
>
>Hi Cetin,
>
>This
>* Cetin Basoz suggestion
>*!*		loExcel.ActiveWorkbook.CLOSE(0)
>*!*		loExcel.ActiveWorkbook.Saved = .T.
>
>gave me an error ActiveWorkBook doesn't evaluate to an object.

Then you don't have an active workbook:) BTW saved line would come first.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform