>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()
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