Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Spreadsheet style grid wanted
Message
 
 
To
02/08/1999 15:58:52
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00248822
Message ID:
00249031
Views:
18
>I found the Worksheet control. How do I get a list of Properties, etc. so I can load up the Worksheet and respond to Clicks,DoubleClicks, etc.?

I am not sure where you can get all the PEMs. The properties on the control I set is the AutoActivate to 3 and AutoVerbMenu to true. Do a search in the files section for Excel. Look at items #816 and 1005. A simple example after dropping this control on a form:
with This.oleExcel
   .DoVerb()    && make the control visible
   with .sheets(1)
      .cells(1,1) = "Results"
      .cells(2,1) = 5
      .cells(3,1) = 10
      .cells(10,1) = "=sum(A2:A8)"
   endwith
endwith
This refers to the form, and I named the control oleExcel for convenience.
Mark McCasland
Midlothian, TX USA
Previous
Reply
Map
View

Click here to load this message in the networking platform