Open Link with VBA

[mattress58]

I have a macro that took me to a report. The report has changed locations. Now the link toakes me to through the network drive and then I have to select the excel report and open it instead of it opening it for me.

This takes me to where the report is:

\\etc-fsnr-02\Shared$\PUBLIC\Users\National Reservations GP76\HOME CITY RATE TEAM\Bid Price Folder\HC one ways\One_Way_Flow.zip

The report is named:

One_Way_Flow.xlsm

I tried this and it doesnt work:

\\etc-fsnr-02\Shared$\PUBLIC\Users\National Reservations GP76\HOME CITY RATE TEAM\Bid Price Folder\HC one ways\One_Way_Flow.zip\One_Way_Flow.xlsm

How can I get this to work. Thanks for help

[ARGK]

Hi
Based on your post it looks like you have the name of a zip file in the path. I believe this is where your issue is. If the document is in a zip file you will need to extract it first before you can open it with a link.
Hope this helps.
Tony