Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Downloads witho...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 29932 of 31576
Post > Topic >>

Downloads without the prompts?

by ManningFan <manningfan@[EMAIL PROTECTED] > Apr 11, 2008 at 01:34 PM

Is it possible to download files without having to click a prompt to
do so?

I'm writing a screen-scrape program for our company, we download tons
of XLS files from government websites.  I scrape all the links into a
table, then run the table through a loop to download the links.
Unfortunately I have to babysit the process and would love to just let
it run in the background.

Part of my code is as such:
*************************************
Set db = CurrentDb
Set rec = db.OpenRecordset("Select * from tblLinks")

Do While rec.EOF = False

  strURL = "" & rec("URL") & ""

     Set objShell = CreateObject("Wscript.Shell")
     Set objIE = CreateObject("InternetExplorer.Application")
        With objIE
         .Visible = False
          .Silent = True
          .Navigate (strURL)
       End With

rec.MoveNext
Loop
*********************************

I tried throwing a SendKeys "{Enter"} command after the End With but
it acted a bit flaky and I'm not sure if it's even right.

Any help would be appreciated.
 




 1 Posts in Topic:
Downloads without the prompts?
ManningFan <manningfan  2008-04-11 13:34:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 1:25:50 CST 2008.