VBA Programming

[Mahendhra]

I am trying to connect an external excel file containing data and import
into the visio drawing. I have written a macro to do that. However, I need
to add a menu so that the user can click that to specify the path of excel
file residing in his computer. I am trying to find a method by which I can
read a file name path and store it and use it.

kindly request your help on this.

Thanks,
Mahendhra

 

[JuneTheSecond]

Microsoft Excel has FileSearch Object and property.
You could use them in Visio, if you would set refernce to the Excel object
library.