Downloading a file from internet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I'm trying to automate a process from access (acccess 2002, windows XP).
I've already done a routine wich enables me to connect to a web site, then
does the adequate request to the web site.

The web site creates then a file (.csv), that I want to download (within the
routine). IE opens a dialog box asking me if I want to Save, Open or Cancel.
I would like to control the box with VBA (to save the file in the appropriate
location with the correct name), but I don't kown how to do this.

Does someone have any clues to help me?

Thank you very much in advance,
Thomas
 
Sendkey don't seem to work well. I tried the command
SendKeys "%S", True (while the dialog box is active) and it doesn't work,
but I don't know why.
Do I something wrong?
 
In fact SendKeys works well, but you have to quit internet Explorer before
(it is at least the only way that I have found to make it work)

Thank you for the advice
 
Back
Top