Hi everyone,
I'm looking to create a diagram in Visio from information contained in an excel spreadsheet.
Down the first column of the spreadsheet is a listing of applications and the same along the top row. An X determines they are linked, share information etc. EG
Is it possible to with the data in this form to create objects in visio and establish links between them where an X is found?Code:App name 1 App name 2 App name 3 App name 1 x App name 2 x App name 3
I imagine I need VBCode, but am really struggling to find any code which utilises excel sheets
Thanks in advance for any help you might be able to provide!


LinkBack URL
About LinkBacks
Reply With Quote