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