Using VTable interface of Excel Component from FoxPro 8.0

Hot Topic

Downloading and uploading file from URL
Report Window
COM server problem
VisualFoxpro9.0 row delete and commit through JDBC
cursorschema property limitation problem
How to get the folder name?
VFP9.0 Data Access from .NET
Image in a Grid
OWC11.PivotTable
Delete record from grid

Visual FoxPro

Need help on a small open table code
directory list
Embed a report into a form…
how to SET DEFAULT TO "running program's dir" ?
report preview form problem
sometimes no response to mouse clicks.
MSComctlLib.TreeCtrl.2 Problem
Application Design
cumulative column calculation
Automate appending data from an MS Access.mdb to two different Foxpro tables (including memo fields)

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

  • Steven in Montreal

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

  • Shankar Joseph

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

  • ThRaShErUk

    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