General information
Category:
Coding, syntax & commands
I've few questions related with excel & vfp...
1. Will this code work with Office 95 also ?? I'm transferring reports in excel but i want to keep my code portable so it can run in all versions..
Yes this code should work with Both versions of office
2. How to chk, whether user has installed office or not ?? (any version), If installed, which is the version ??
Try This
X = 0
* Turn errors off
On Error X = 1
loExcel = CreateObject("Excel.Application")
IF X = 1
* Excel Not Loaded on this machine
ELSE
* Excel is loaded on this machine
ENDIF
On Error
3. What is the best way to transfer data to excel i.e.
(a) copy to xls command
(b) copying to clipboard & pasting it
(3) oXls(row,col).value = ????
Number 3 is the best way I think. You have so much more control over the data
Thanks
Darren
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only