Editing embedded Excel sheets in Visio

[Seption]

I'm trying to use a macro to edit cell values in an embedded Excel Worksheet.
The embedded worksheet is only in the Visio page, it's not linked to an
actual Excel spreadsheet. I have tried to use the macro recorder to get the
code I need, but the only code it records is me selecting the Worksheet
object, and it doesn't record anything when I change cell values.

Any help would be appreciated. Suggestions?

 

[WapperDude]

Once you open the Excel spreadsheet, you've crossed the boundry from Visio to
Excel, and the Visio macro recorder can no longer see your actions/edits.
I've not tried this, and I don't remember if Excel records steps either, but,
if somehow you do have a macro to work within Excel, then, you might be able
to include that code in the Visio macro. That is, Visio 1st selects the
spreadsheet and opens it, and then the imported Excel code does the editting.

If the Excel data is linked to shapes, you might want to check out this
link:
http://office.microsoft.com/en-us/visio/HA101154651033.aspx?pid=CH100991501033

HTH
Wapperdude