Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Useful DBF2Excel routine
Message
From
17/02/2006 16:39:18
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Useful DBF2Excel routine
Miscellaneous
Thread ID:
01097203
Message ID:
01097203
Views:
81
Oops, just googled Dbf2Excel and found FoxyClases is using that name for one of their classes. Sorry about that.

Alex

Hi,

I needed this little routine and thought it may be useful to others:
* DBF2Excel.prg This routine is meant to be called with a table open in current area
* Creates table in FOX2X format and opens with Excel
LOCAL lcTemp,loExcel
lcTemp = FORCEPATH(SYS(2015) + '.tmp',SYS(2023))
COPY TO (lcTemp) FOX2X
loExcel = CREATEOBJECT('Excel.Application')
loExcel.WindowState = -4137  && xlMaximized 
loExcel.Workbooks.Add(lcTemp)
loExcel.Visible = .t.
Alex
Next
Reply
Map
View

Click here to load this message in the networking platform