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.