Help ! Visio and Excel

[JoanaChang]

How can I access Excell tables from the VB editor of Visio ?
I need to read (not import) data from there and store data too..

Visio can do that right

 

[JuneTheSecond]

I could not carify the difference between read and import that you mean.
But it might start from Createobject("excel.application") or
GetObject(,"ex....).

 

[Al Edlund]

visio supports vba natively so, yes you can read and write to excel tables
using custom code.
That connectivity is not native to the product so somebody will have to
write it.

there's some example code embedded in here on how to write..

http://msdn2.microsoft.com/en-us/library/aa140253(office.10).aspx

al