Using VTable interface of Excel Component from FoxPro 8.0

Hot Topic

MSGraph.Chart.8 control
Detect hard diskk serial number.
createobject("mappoint.application)
problems on textbox in VFP
Combine records into 1 text box using ALLTRIM
Blinking Vertical Line hard to see in a textbox
"feature is not available" - complete diagnostic
Coming from Excel to VFP9 and need help understanding math functions on cells
Good references for a beginner?
Data design for my application - Comments welcome

Visual FoxPro

report labels
New to VFP please recomend any good books
Report that won't maximize
what is the maximum field VFP9 can handle
MSCharts.ocx
Spell checking?
Accessing FoxPro from C++
Packing a table
Very nice!
COM application using to much memory

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

  • Ralph Depping

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

  • jacobmross

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

  • Satie Cheung

    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