This is not my website so I unfortunately cannot change the code. There is jscript in the website header. There is also references to external jscripts. I can post the header if you would like but it is very long. I don't know javascript so reading it is only helpful to a point.
The html source for the item I am clicking to start the download is:
HTML Code:
<a class="NQWMenuItem" name="SectionElements" href="javascript:void(null);" onclick="NQWClearActiveMenu();Download('saw.dll?Go&_scid=DsZsoFas5E8&ViewID=d\x253adashboard\x257ep\x253aapnl74vr5ch30r06\x257er\x253a869hck781l4bksg9&Action=Download&SearchID=tf0ds3t0n47g9igkk3p3hv2nnm&PortalPath=/shared/IR\x2520ITS\x2520Sourcing\x2520and\x2520Supply\x2520Chain/_portal/Supplier\x2520Dashboard&Page=Supplier\x2520Open\x2520Orders&ViewState=312b0nq6c4v0p9eeib7dlkif0a&ItemName=R40GSS-\x2520Supplier\x2520Open\x2520Order\x2520Report&Format=mht&Extension=.xls'); return false">Download to Excel</a>
Creating a second IE tab to call the jscript directly is something I considered but I don't know how to do that. I was also wondering if there was a way to grab the url before IE navigated to it and then call that in VBA using the navigate function so it would be part of the IE object I declared. I am still fairly new to VBA so I don't know how to go about doing either of those things.
Thank you for your help! It is much appreciated.