[AccessD] Automating file downloads from the Web **SOLVED**

Jim Lawrence accessd at shaw.ca
Tue May 31 12:33:45 CDT 2005


Really cool Jim... That program could be very handy given the right problem.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Tuesday, May 31, 2005 7:25 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Automating file downloads from the Web **SOLVED**

I found a macro recorder that allowed me to create a sophisticated script
that worked. It is called Macro Scheduler 7.3 with the associated
MacroScript WebRecorder. It can be found at
http://www.mjtnet.com


Jim Hale

-----Original Message-----
From: Joe Hecht [mailto:jmhecht at earthlink.net]
Sent: Wednesday, May 25, 2005 7:05 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Automating file downloads from the Web


Jim,
A man in my users group may have a tool for this. May I pass this e mail to
him?

Joe Hecht
Los Angeles CA

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hale, Jim
Sent: Wednesday, May 25, 2005 1:51 PM
To: 'Accessd (E-mail)
Subject: [AccessD] Automating file downloads from the Web

I have created an Access database that parses Bank of America credit card
Merchant statements. I manually download individual merchant statements from
B of A's web site and process them with Access. All this works wonderfully
well. The problem is we have 158 stores (merchant statements) that have to
be downloaded. Each download requires clicking through about 5 separate
screens. It takes about 4 hours. B of A has made it abundantly clear they
can not provide a disc with all the statements or any other means to
download the statements in a group so I am left to my own devices. Is there
any kind of script/key macro/magic I can write to at least semi automate the
download process? Any help would be appreciated since I have some clerks
ready to lynch me. TIA

Jim Hale


***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.




More information about the AccessD mailing list