File Downloads in VBA

[Guest]

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,

 

[Amedee Van Gasse]

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

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.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html

 

[Guest]

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