boblarson
Smeghead
- Local time
- Today, 11:47
- Joined
- Jan 12, 2001
- Messages
- 32,059
I need to download several files from a website for processing, and I can sort of get it to work, but I am at a loss at the moment to figure out how to actually save the files.
I am currently using:
and it works. It downloads the csv file, but automatically opens it in Excel instead of giving me the option to save it. I am creating this for multiple users, so I can't just change my file associations.
Anyone done this type of thing before?
I am currently using:
Code:
Application.FollowHyperlink "https://ebctest.cybersource.com/ebctest/TransactionExceptionDetailReport.csv"
and it works. It downloads the csv file, but automatically opens it in Excel instead of giving me the option to save it. I am creating this for multiple users, so I can't just change my file associations.
Anyone done this type of thing before?