VBA - Go to website and download file from save prompt

Hello,

I've been spending the last few hours trying to figure out how to save a file onto the computer using VBA. The code template below that I found on another forum seems promising, except when I go to the desktop to access it, the .csv file has what looks like the page's source code instead of the actual file I want. This may be because when I go to the url, it doesn't automatically download the file; rather, I am asked to save the file to a certain location (since I don't know the path name of the uploaded file on the site).
Is there any way to alter this code to accomodate this, or will I have to use a different code entirely? Thanks!

Please Login or Register  to view this content.

Cross-posts:
http://www.ozgrid.com/forum/showthread.php?t=178884
http://stackoverflow.com/questions/1...om-save-prompt