Import to Access from Excel File created by ASP Page

[tssrshot]

Big picture, I am trying to get Access to Import, regularly, an Excel Document which comes from an external ASPnet based website.



I can do it manually, but going to the site, clicking the link, saving the Excel to my computer, and then importing to the Database.

The problem is, I'm the only one who knows how to do that, and it needs to be user safe.
We have about 40 High Visibility users (military guy here) and the site is completely managed by another agency who will not cooperate.

I can get VBA to open a IE window but I can't get it to click the link or import the excel and have no way of knowing how ASPnet works to get a way around this pickle. The link I click says, in its source,

javascript:__doPostBack('ctl00$mnuMain','Alpha Roster')>Alpha Roster</A>

For a user, if he wants the Excel data, he goes to the site, logs in with his Smartcard via IE, and clicks on the link which pops up a request to save/open/cancel an Excel file. I've imported this to a table in our database, but the data gets out of date, immediately. The site the data comes from is from another branch of the government, so they WILL NOT assist us with an SQL connection or anything. They just say, "import every day, sorry!"Any advice would be GREAT! Any more information needed, please let me know!

[June7]

Google: VB download Excel file from website

Does this help http://www.cpearson.com/Excel/DownloadFile.aspx

[tssrshot]

I was thinking of that method in my original search...the hard part is getting the file as its not accessable directly. For instance, you can't go to URL://something.com/file.xls. You go to url://something.com/file.aspx and then click a link that opens the excel download dialog.

[June7]

So you need to open web page, search the page for URL string, and open it. Review http://us.generation-nt.com/answer/v...1358102.html#r