accessing external excel data without linking to shapes

Started by guitar_shot, October 24, 2020, 05:51:54 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

guitar_shot

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)?