I have an excel table and I follow the steps on How to link a Visio drawing to a specific region in an Excel worksheet - Office where I'm able to get to step 12. At this point I get the error, "Visio is unable to change the link source as requested." when I click "Open" after entering the item name. It then leaves Excel open so that I have to manually close it in the task manager before I can access the data again.
The steps up to point 12 I recorded a macro to try and see what it's doing and I get:
"Application.ActiveWindow.Page.InsertFromFile "C:\path\file.xlsx", visInsertLink"
The goal is this:
I have an excel file that I'm treating like a database. A second excel file links to this first file using PowerQuery and creates equipment schedules. Then I have a Visio document that has drawings for those pieces of equipment. I would like to create a button which will Input the equipment schedules into Visio.
The steps up to point 12 I recorded a macro to try and see what it's doing and I get:
"Application.ActiveWindow.Page.InsertFromFile "C:\path\file.xlsx", visInsertLink"
The goal is this:
I have an excel file that I'm treating like a database. A second excel file links to this first file using PowerQuery and creates equipment schedules. Then I have a Visio document that has drawings for those pieces of equipment. I would like to create a button which will Input the equipment schedules into Visio.