Get info from external web page

[Wayne-I-M]

Posted to the Access forum and Frontpage Forum

Hi

This may not be possible - but hope so.

I have an access database that is used to keep check on the cost of our
hotels in Italy. We need to convert the costs from Euros (the purchase
currency) to UK Pounds (the sale currency).

At the moment I have a access form where the a user will click a button
(with a hyperlink OnClick) open the webpage and they then type in the rate.

But can this be done auto.

Can I refer to a cell on a webpage form - copy the number from the cell -
paste it into and access form control.

Been playing around with this but wondered if anyone has this set up all
ready and would share a few tips.

The website we use is
http://www.xe.com/

As you can see there is a table and in the UK Po9und / Euro - converse
<td align="center" class="cur1 currencyB">Number Here</td>

I just need to insert this Number Here cell into my form control

Any Ideas ??

Thanks

 

[MikeR]

Posted to the Access forum and Frontpage Forum

Hi

This may not be possible - but hope so.

I have an access database that is used to keep check on the cost of our
hotels in Italy. We need to convert the costs from Euros (the purchase
currency) to UK Pounds (the sale currency).

At the moment I have a access form where the a user will click a button
(with a hyperlink OnClick) open the webpage and they then type in the rate.

But can this be done auto.

Can I refer to a cell on a webpage form - copy the number from the cell -
paste it into and access form control.

Been playing around with this but wondered if anyone has this set up all
ready and would share a few tips.

The website we use is
http://www.xe.com/

As you can see there is a table and in the UK Po9und / Euro - converse
<td align="center" class="cur1 currencyB"

I just need to insert this Number Here cell into my form control

Any Ideas ??

Thanks

Call Wininet.dll functions from a bit of VBA code to read the web page into a string.
Parse the string to get what you want. There are a number of the "<td align="center"
class="cur1 currencyB" elements in that table. If you are looking for a particular
one, I see no way to distinguish it, other than it's order in the hierarchy. One big
gotcha that can crop up is if the web site design changes.

How to call a dll from VBA.

http://msdn.microsoft.com/en-us/library/aa165195(office.10).aspx

Wininet functions
http://msdn.microsoft.com/en-us/library/aa385483.aspx

I've never done this from VBA, but I have done it from a Delphi program. If you like,
contact me off list, and I'll see if I can help further.

Mike

 

[Wayne-I-M]

Think this may be a non-starter.

Not too hard into excel (using Excel Web Query) and then import it into
access. Would have thought there would be something like this in access - if
there is I can't find it. You are right about the site moving stuff around
causeing it to fail.

I looked at importing it into frontpage (then I can name the cells) then do
a simple import into access. - works, sort off. But it just looks like it's
set up to fail.

Oh well it was just an idea.

If anyone reads this who has vista access, does the new 2k7 access have
something like excel web query ??

If not think will just drop the idea and get on with something else.

 

[MikeR]

Think this may be a non-starter.

Not too hard into excel (using Excel Web Query) and then import it into
access. Would have thought there would be something like this in access - if
there is I can't find it. You are right about the site moving stuff around
causeing it to fail.

I looked at importing it into frontpage (then I can name the cells) then do
a simple import into access. - works, sort off. But it just looks like it's
set up to fail.

Oh well it was just an idea.

If anyone reads this who has vista access, does the new 2k7 access have
something like excel web query ??

If not think will just drop the idea and get on with something else.

OK. Sounded like a neat project tho....Good luck.