Get Unit Rate from Web site directly to MS Access (1 Viewer)

[mobarak ahmed]

Hi dears
In form invoice
i want to get US Dollar (Unit rate) in case the Project currency is USD from this site
for example invoice to : AC Boilers EGYPT -- Project name : Cairo West E USD 10089-CP-105 / Electrical I&C Supply and Installation
to be paste on "Currency Unit Rate" Text box
* date is the same date as today
* Buy rate

 

[Pat Hartman]

What is the code you are using?

 

[mobarak ahmed]

What is the code you are using?

I want the code . I don’t have one

 

[Gasman]

I want the code . I don’t have one

So no attempt to try for yourself?
I think you might have to wait for @arnelgp to see the post. He has done some work with webscraping and tends to write all the code for people who do not want to do it themselves.
I had a look and you also have to put in the required currency to start with? Looks very interactive when you use it, no explicit url to pick up on?

 

[mobarak ahmed]

I have tried but I failed.. the url when you choose date and currency and click show data .. doesn’t contain the choices
I have looked up in the inspect but it’s very complicated for me

So no attempt to try for yourself?
I think you might have to wait for @arnelgp to see the post. He has done some work with webscraping and tends to write all the code for people who do not want to do it themselves.
I had a look and you also have to put in the required currency to start with? Looks very interactive when you use it, no explicit url to pick up on?

 

[Gasman]

I have tried but I failed.. the url when you choose date and currency and click show data .. doesn’t contain the choices
I have looked up in the inspect but it’s very complicated for me

Probably to avoid exactly what you are trying to do?
Have you looked at other sites where you can supply values to get an actual url where you can scrape the values?

 

[mobarak ahmed]

Probably to avoid exactly what you are trying to do?
Have you looked at other sites where you can supply values to get an actual url where you can scrape the values?

Unfortunately this the only official and approved site in our work field

 

[mobarak ahmed]

i am sure he will
@arnelgp

 

[arnelgp]

test your Exchange rate (buying dollar).

 

[Pat Hartman]

Have you looked at the documentation on this page?

Central Bank of Egypt

Central Bank of Egypt

www.cbe.org.eg

The papers are in Arabic so I can't tell if they are insturctions. Look for things that talk about REST which is a common interface protocall.

 

[mobarak ahmed]

test your Exchange rate (buying dollar).

your are the best no doubt , thank you , thank you for everything

 

[mobarak ahmed]

Have you looked at the documentation on this page?

Central Bank of Egypt

Central Bank of Egypt

www.cbe.org.eg

The papers are in Arabic so I can't tell if they are insturctions. Look for things that talk about REST which is a common interface protocall.

thank you for helping me , i think we don't need to know , but thank you i appreciate

 

[Gasman]

test your Exchange rate (buying dollar).

@arnelgp
Any chance of a 2007 version please?

 

[arnelgp]

i removed my vmware so only office 2021 x64 is installed.

 

[Gasman]

i removed my vmware so only office 2021 x64 is installed.

Ah well, not to worry.

 

[mobarak ahmed]

test your Exchange rate (buying dollar).

could we link the date of Exchange rate with invoice date , as i tried to change the date but still have the same rate

 

[arnelgp]

i download the excel file exchange rate from 2020 upto Oct 4, 2021 and
import it to tblExchangeRate. these rate are historical, so it will not
change. this is to prevent going to the site everytime an old invoice_date is typed.

 

[mobarak ahmed]

i download the excel file exchange rate from 2020 upto Oct 4, 2021 and
import it to tblExchangeRate. these rate are historical, so it will not
change. this is to prevent going to the site everytime an old invoice_date is typed.

so should i update this table every month or period ?
i think if it possible to link invoice date directly to the site it would be better
as it will be automatically updated

 

[arnelgp]

i think if it possible to link invoice date directly to the site it would be better

you can't link it, the site is a Form, so you need to fill up the
form first before you can Download the excel file.
if you are not creating an invoice, retro-active, you
do not need to update the table.

 

[Pat Hartman]

It is easiest to save the current exchange rate when you add a new transaction. That way history takes care of itself. You only ever need to worry about getting the CURRENT exchange rate.

Exchange rates vary, sometimes wildly, throughout the day and potentially more throughout a month. I think credit card companies use the closing rate for the "day" whatever that is to process charges made that day.

I couldn't use arnel's sample so I don't know how it works. It sounds like it is screen scraping to download the exchange rates. Most sites like this offer an API so you can find a single exchange rate without resorting to screen scraping.. The site will provide documentation. That is what I was hoping you would find in the documents I point you to. Sites have different rules. Most will offer a paid service and a free one. The "get one rate" per day is almost always free.