I created a macro that pulled up a file and got a range and then closed the file. The issue now is the company switched it to a zip file for size reasons. How can I change my code to get the range?

This did work:
HTML Code: 
Here is the link to the new file, then I have to click it to open it. The new file name is "One_Way_Flow.xlsm"

HTML Code: 
I have been trying to do this all week. Thanks for help