New
#1
Automate Visio file(s) search via Excel or Explorer
New to the forum, and hoping that there already exists a solution to my problem, or that the community gurus can help...
I was tasked at work with creating several new pages (multiple files) of Visio schematics. I have an Excel spreadsheet that lists the major components as a sort of Bill Of Materials. Each major component has a Reference Designator (i.e. "2A7") associated with it.
I would like a way to automatically search through all of the Visio files to determine on which file(s) each Reference Designator appears. I can do the job manually by simply typing "2A7 " into the Windows Explorer Search window. But, obviously, this takes a lot of time, is prone to me transcribing something wrong, and requires me to re-do a search any time something changes, either on the drawing files or the BOM.
I've asked the same question on an Excel forum, and there's apparently some limitation that VBA has with accessing Visio's .vsd files.