Author Topic: accessing external excel data without linking to shapes  (Read 109 times)

0 Members and 1 Guest are viewing this topic.

guitar_shot

  • Newbie
  • *
  • Posts: 1
accessing external excel data without linking to shapes
« on: October 24, 2020, 12:51:54 PM »
Hello,

I am very new to Visio and programming in general, including VBA.

I am trying to access data from external excel file (sitting in the same file directory as my visio).

So, I have imported excel sheets to my Visio file. I am thinking of NOT linking them all to the Shapes just to keep the minimum number of property fields in each shape data. I just want to access and grab necessary data whenever required in VBA.
Is this even possible to do? (accessing imported external data that are not linked)
 

Or... am I better off accessing those external excel files directly, without importing to Visio?
Could you provide a sample VBA code on how to access external Excel spreadsheet (i.e. for example, Sheet 1, B5 data)?