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!