Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE Automation
Message
From
07/08/1997 00:33:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
OLE Automation
Miscellaneous
Thread ID:
00043474
Message ID:
00043474
Views:
90
Is there any way I can trap errors when doing OLE automation to EXCEL (any MS products) instead of me getting unfriendly error message? How do I check whether EXCEL is installed in my customer PC so that I can disbale the command button to launch EXCEL.

I would like to highlight rows in the EXCEL with different color based on exceeded value on the row cells. How can I do this or command I can use. I have tried recording the macro and typing the commands but this does not work. The macro recorded is as follows : (how do I translate this in VFP)

.Row('7:7').Select
With Interior.Selection
.ColorIndex=6
.Pattern=lssolid
ENDWITH

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform