Using VTable interface of Excel Component from FoxPro 8.0

Hot Topic

Median calculation
Using Browse command in VFP9
Time format saved a character field
Excel Automation - Charts.
12 hour time format
FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02
stop “invalid input”
data from one table1 that isn't in table2
CA
Preview container toolbar doesn't respond

Visual FoxPro

VFP 9.0 SP1 Released Today
Changing Report Label Text At runtime using ReportListeners
qbf
Problem Installing VFP 9.0
foxpro2.5 application migration from windows98 to XP (Urgent)
SELECT statement is showing unwanted display of data and is not passing data to a table.
MSGraph.Chart.8 control
Encryption Questions
MSComctlLib.TreeCtrl.2 BackColor ???
FoxPro v9 vs Visual dBASE Plus 2.01 BDE 5.2.02

Using VTable interface of Excel Component from FoxPro 8.0

I am writing a FoxPro program that uses the Microsoft Excel component in order to generate a XLS file. However, FoxPro is evidently using the IDispatch form of the Excel interfaces instead of the VTable interface. How do I write the program so that FoxPro will use the VTable interface instead


Answer this question

Using VTable interface of Excel Component from FoxPro 8.0

  • julioc_aragonj

    Check CreateObjectEx() and sys(2333).
    My curiosity why do you need Vtable interface to create an XLS file

  • r prasanna vignesh

    Your welcome. 70000 rows is not too much, strange you needed it.

  • WeBMartians

    Sorry it took so long to acknowledge your reply.  The component is working fine using CREATEOBJECTEX().  We were importing and programatically formatting in excess of 70,000 rows of data in Excel and were having performance problems.  Our IT dept suggested using VTABLE instead of IDispatch.

    Thank you for your expertise.

  • Using VTable interface of Excel Component from FoxPro 8.0
Answer this question