Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Controlling Excel97 from VFP5
Message
From
08/07/1999 07:53:14
 
 
To
08/07/1999 02:40:42
Vinod Parwani
United Creations L.L.C.
Ad-Dulayl, Jordan
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00238364
Message ID:
00238755
Views:
14
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
Map
View

Click here to load this message in the networking platform