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