Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-09-2010, 02:40 PM   #1
iworkonline
Newly Registered User
 
Join Date: May 2010
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
iworkonline is on a distinguished road
Screen scraping in MS Access

Hi Guys

I have been asked to write a VBA code that will get data from Internet Explorer and store it in Access tables. Internet Explorer is already open and the page that I am extracting data from is already displayed.
Is it possible to do it in Access 2003?

Thanks.

iworkonline is offline   Reply With Quote
Old 08-10-2010, 02:20 PM   #2
NigelShaw
Newly Registered User
 
NigelShaw's Avatar
 
Join Date: Jan 2008
Location: Leicester UK
Posts: 1,562
Thanks: 8
Thanked 69 Times in 45 Posts
NigelShaw is on a distinguished road
Re: Screen scraping in MS Access

Hello

Yes I think it is possible. Do a search on AJTrumpet as he seems to be the HTML - VBA whizz round here

Nidg
__________________
Never, ever, argue with an idiot. They'll drag you down to their level and beat you to death with experience!

If i have helped you in any way, please tip my scales or say a little thanks
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Chars

Checkout my splash screen tool
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
for a free download.
NigelShaw is offline   Reply With Quote
Old 08-10-2010, 02:22 PM   #3
SOS
Registered Lunatic
 
SOS's Avatar
 
Join Date: Aug 2008
Location: Somewhere between here and there
Posts: 3,517
Thanks: 2
Thanked 59 Times in 54 Posts
SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light
Re: Screen scraping in MS Access

Quote:
Originally Posted by NigelShaw View Post
Hello

Yes I think it is possible. Do a search on AJTrumpet as he seems to be the HTML - VBA whizz round here

Nidg
WAS until he got himself banned.

SOS is offline   Reply With Quote
Old 08-10-2010, 02:25 PM   #4
NigelShaw
Newly Registered User
 
NigelShaw's Avatar
 
Join Date: Jan 2008
Location: Leicester UK
Posts: 1,562
Thanks: 8
Thanked 69 Times in 45 Posts
NigelShaw is on a distinguished road
Re: Screen scraping in MS Access

Ooooohh,

Didn't know that! Hope it wasn't too bad. His posts are are still here though right?

Nidge
__________________
Never, ever, argue with an idiot. They'll drag you down to their level and beat you to death with experience!

If i have helped you in any way, please tip my scales or say a little thanks
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Chars

Checkout my splash screen tool
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
for a free download.
NigelShaw is offline   Reply With Quote
Old 08-10-2010, 02:26 PM   #5
SOS
Registered Lunatic
 
SOS's Avatar
 
Join Date: Aug 2008
Location: Somewhere between here and there
Posts: 3,517
Thanks: 2
Thanked 59 Times in 54 Posts
SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light SOS is a glorious beacon of light
Re: Screen scraping in MS Access

The posts are still here even if he isn't.
SOS is offline   Reply With Quote
Old 08-10-2010, 02:37 PM   #6
iworkonline
Newly Registered User
 
Join Date: May 2010
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
iworkonline is on a distinguished road
Re: Screen scraping in MS Access

Oh well I will try some other forum.
iworkonline is offline   Reply With Quote
Old 08-11-2010, 12:46 AM   #7
darbid
Newly Registered User
 
Join Date: Jun 2008
Location: Munich
Posts: 1,428
Thanks: 6
Thanked 37 Times in 34 Posts
darbid will become famous soon enough
Re: Screen scraping in MS Access

Quote:
Originally Posted by iworkonline View Post
Hi Guys

I have been asked to write a VBA code that will get data from Internet Explorer and store it in Access tables. Internet Explorer is already open and the page that I am extracting data from is already displayed.
Is it possible to do it in Access 2003?

Thanks.
yes it is possible. What is the internet page and what data do you want from it?

darbid is offline   Reply With Quote
Old 08-11-2010, 12:52 AM   #8
darbid
Newly Registered User
 
Join Date: Jun 2008
Location: Munich
Posts: 1,428
Thanks: 6
Thanked 37 Times in 34 Posts
darbid will become famous soon enough
Re: Screen scraping in MS Access

and a link to get you started http://www.access-programmers.co.uk/...d.php?t=176968
darbid is offline   Reply With Quote
Old 08-11-2010, 07:23 AM   #9
iworkonline
Newly Registered User
 
Join Date: May 2010
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
iworkonline is on a distinguished road
Re: Screen scraping in MS Access

Hey Darbid

After looking at the post this, I can get started. What I am doing is this, I have to look for specific text and then copy the values next to it.

I really don't have words on how to offer my thanks. You guys saved my job.
iworkonline is offline   Reply With Quote
Old 08-11-2010, 08:35 AM   #10
iworkonline
Newly Registered User
 
Join Date: May 2010
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
iworkonline is on a distinguished road
Re: Screen scraping in MS Access

I have asked a question which is realted to the linked post. Please answer it if you can. Thanks.
iworkonline is offline   Reply With Quote
Old 08-11-2010, 08:45 AM   #11
darbid
Newly Registered User
 
Join Date: Jun 2008
Location: Munich
Posts: 1,428
Thanks: 6
Thanked 37 Times in 34 Posts
darbid will become famous soon enough
Re: Screen scraping in MS Access

Quote:
Originally Posted by iworkonline View Post
I have asked a question which is realted to the linked post. Please answer it if you can. Thanks.
what? Where?
darbid is offline   Reply With Quote
Old 08-11-2010, 09:01 AM   #12
iworkonline
Newly Registered User
 
Join Date: May 2010
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
iworkonline is on a distinguished road
Re: Screen scraping in MS Access

I just did
iworkonline is offline   Reply With Quote
Old 08-11-2010, 09:18 AM   #13
darbid
Newly Registered User
 
Join Date: Jun 2008
Location: Munich
Posts: 1,428
Thanks: 6
Thanked 37 Times in 34 Posts
darbid will become famous soon enough
Re: Screen scraping in MS Access

I am not sure you should put questions there. I think you need to ask a new question or even put it here.
darbid is offline   Reply With Quote
Old 08-11-2010, 09:51 AM   #14
iworkonline
Newly Registered User
 
Join Date: May 2010
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
iworkonline is on a distinguished road
Re: Screen scraping in MS Access

The website is a password protected website.

The user first logs in the site and then use the web based application by entering the shipper number and then it generates some results.

At this point the user wants to click a button on the Access form that will extract the data from the webpage and copy over in Access tables.

How do I reference the already opened IE Window. Plus I have multiple IE windows open.

I am using a pretty old IE version 6.0

Thanks.
iworkonline is offline   Reply With Quote
Old 08-18-2010, 11:39 PM   #15
darbid
Newly Registered User
 
Join Date: Jun 2008
Location: Munich
Posts: 1,428
Thanks: 6
Thanked 37 Times in 34 Posts
darbid will become famous soon enough
Re: Screen scraping in MS Access

Sorry I did not see your post. Did you get the opening of the IE solved. There are thousands of examples of this.

As you website is passworded. It is difficult to help - in fact a little annoying - but lets see.

darbid is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Screen Capture Access Form to JPG BackoSoft Modules & VBA 16 04-20-2009 07:13 AM
Avoiding database login screen everytime MS Access DB moves to different system ashokbh98 General 0 10-09-2006 03:15 PM
Access Screen Freezes then the forms don't work TheEvilBankers General 5 08-09-2005 09:43 AM
MS Access screen resolution ebw General 2 12-07-2004 11:23 PM
Hiding the Access Screen on startup rdrunner Modules & VBA 4 11-12-2001 04:55 AM




All times are GMT -8. The time now is 08:46 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World