Editing an existing Excel table via VB

[MusicDude]

I cannot find the code to allow me to edit an existing Excel table in a drawing. I have all the code working that changes the actual cells, but I can't find what I need to make the table "active"- the equivalent of double clicking on it. Any suggestions?

 

[PDMAdmin]

Is it an Excel-based BOM? If so, the following commands should work.

BomTable::Attach3
BomTable:etach

 

[MusicDude]

It's not a BOM, but it is Excel-based. It's just a standard MS Excel Worksheet that was inserted either by Insert\Object\Worksheet or copy/pasted in.

 

[EvanBasalik]

Well, I thought ObjectDisplayasContent would work, but...

What else have you tried?


Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...

 

[MusicDude]

ModelDoc2.ActivateSelectedFeature did the trick (thanks Earl). That worked great to get me into edit mode, now I cn't figure out how to get out of it! I have used selectbyID to pick a blank spot (which should kick me out of editing the table), but it doesn't do anything. I need a "deActivateSelectedFeature" ... but haven't found anything yet.

 

[EvanBasalik]

What if you just select another feature? Or, clear selection?

Evan T. Basalik, MCSD
--------------------------------
It's all about prioritization...

 

[MusicDude]

I have used selectbyID to pick a blank spot (which should kick me out of editing the table), but it doesn't do anything. I also have tried selecting a view and activating it- it didn't like that at all.