Open embedded Excel file in Visio through VB

V

Visio Monster

Any help would be greatly appreciated.

I am trying to open an Excel file that I have embedded in in Visio with VB.
Does anyone know what the right path is?

I have written a module that can open an existing excel file on my desktop
and filter through data and display data when I double click on a shape on my
sheet. But the only catch is I have to set the path to the specific location
where the file is.

Does anyone know of a way to open the excel file so I might be able to send
others my file without the hassle of setting up the path. One idea I had was
to put the excel file on the web and have the module link to that central
location.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio to Excel 0
Visio shape text disappears upon copy paste 1
Default local file location - folder redirection slowness 0
Extract embedded excel file from word document 0
Visio 2019 crashes when attempting to open drawing. 0
Match table shading (color) to Visio color/Transparency 1
Embed the same Excel multiple times 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top