File Downloads in VBA
 

I'm trying to automate file downloads. Within VBA I'm accessing a hyperlink
that pops up a file download dialog box, how do I automate key pressing to
open or save the file?
(I'm using Excel2003.)
TIA,

Thanks Amedee, unfortunately I'm trying to download from an http address.

"Amedee Van Gasse" wrote:

Sysygy shared this with us in microsoft.public.excel.misc:

I'm trying to automate file downloads. Within VBA I'm accessing a
hyperlink that pops up a file download dialog box, how do I automate
key pressing to open or save the file?
(I'm using Excel2003.)
TIA,

I would create a text file with ftp commands, and parse that through
the commandline ftp client. That's how I would do it, if it's a ftp
download. For http, I don't know.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html