How Do I???

[grousedog]

How do I call methods on an ActiveX control in VB?
I have plance the control in an Excel Spreadsheet and I want to get the current value of the control...specifically the date and assign it to a cell. I am confused about the LinkedCell property and how/if I can use this. Thanks

[Weasel]

Are you wanting to access an activeX controls methods or open en Excel file?

Use DAO top open Excel, rather than embedding it in an object.

5 methods showed for the Workseets in Excel:
Drag, Move, SetFocus, ShowWhatsThis, ZOrder
To use SetFocus, if the embedded object was Sheet1 you would use:
Sheet1.SetFocus

On typing the object name and hitting . a list should come up, anything with an
icon like that for SetFocus is a method, and can be used the same way