link external excel cell to text box shape

F

fj

I'm trying to link simple text box shapes to an external data source (perferably an excel spreadsheet cell, but csv text would be ok too) so that the contents of the cell would be displayed in the visio drawing as text contents. This so I can build a formated table inside visio with external data.

I've spent a couple hours trying to get link to database, etc by way of tools->add-ons->visio-extras->XX with no success.

any pointers?

fj..
 
A

Al Edlund

I'd start with David Edson's book since he has some good examples of office
integration in it, and one of them has an embedded excel spreadsheet so you
don't have to fool with tables (assuming that would be acceptable).
Al
fj said:
I'm trying to link simple text box shapes to an external data source
(perferably an excel spreadsheet cell, but csv text would be ok too) so that
the contents of the cell would be displayed in the visio drawing as text
contents. This so I can build a formated table inside visio with external
data.
I've spent a couple hours trying to get link to database, etc by way of
tools->add-ons->visio-extras->XX with no success.
 
F

fj

that sounds excatly like what I need.

thanks
fj.

----- Al Edlund wrote: ----

I'd start with David Edson's book since he has some good examples of offic
integration in it, and one of them has an embedded excel spreadsheet so yo
don't have to fool with tables (assuming that would be acceptable)
A
fj said:
I'm trying to link simple text box shapes to an external data sourc
(perferably an excel spreadsheet cell, but csv text would be ok too) so tha
the contents of the cell would be displayed in the visio drawing as tex
contents. This so I can build a formated table inside visio with externa
data
 
Top