How to open a website and click on a link and open the file to capy

I am trying to open a website "http://transport.dot.state.mn.us/Reference/refItem.aspx" from excel and then click on a link there which will ask if I want to "open" "save" or "cancel", and I would click to "Open". It will open an excel file named "TrnsportItemList.xlsx" and sometimes "TrnsportItemList (1).xlsx" at which time I will copy the data and past into my excel workbook for reference.

can anyone help?

I was having trouble posting this part of my reply above

the Link text Export To CSV has this code attached to it

j a v a s c r i p t : _ _ d o P o s t B a c k ( ' c t l 0 0 $ M a i n C o n t e n t $ L i n k B u t t o n 1 ' , ' ' )

note I had to put a space between each character or this website would not let it be posted.
so if you want to test it copy and remove all spaces.

and then when you put it in the address bar of IE it will drop the "Javascript" & the ":_" part and give you a google search result.
to get it to work I typed a "t" in the address bar then pasted the code then deleted the "t" and clicked enter, all on the MnDOT webpage noted earlier.