https://www.aifa.gov.it/liste-dei-farmaci
based this web site how to get all .csv link (see download)
for example from table (0) is "https://www.aifa.gov.it/documents/20142/847339/elenco_medicinali_carenti.csv"
if is possible iwthout IE object, but with api GET
Last edited by sal21; 07-01-2025 at 03:58 AM.
Try it
OR
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by hungt; 07-01-2025 at 06:06 AM.
great bro! tks.Originally Posted by hungt
Try it
ORPlease Login or Register to view this content.
Please Login or Register to view this content.
only one tips for each table i need to get also a: Data ultimo aggiornamento:
for example
first table
Data ultimo aggiornamento:18/06/2025 is for:
is for https://www.aifa.gov.it/documents/20...quivalenti.csv
second table
Data ultimo aggiornamento:Aprile 2025 is for:
https://drive.aifa.gov.it/farmaci/confezioni.csv
https://drive.aifa.gov.it/farmaci/PA_confezioni.csv
https://drive.aifa.gov.it/farmaci/atc.csv
.... ecc
Last edited by sal21; 07-01-2025 at 06:33 AM.
Try it
Please Login or Register to view this content.
Last edited by hungt; 07-01-2025 at 07:42 AM.
GREAT !!!!!
tks bro
i bro but when you test the code recive the alert such as in image
1. If you want to show a message in this window, write. I'm old and I can't see this writing anymore - small print. I saved the image and enlarged it in Paint but the writing will be blurred, unclear.
2. I don't know English, I don't know Italian. I won't type this message in Google Translate anyway. Question: why should I bother? You could have provided the content of this message.
3. I don't have this message. You can see in the picture that the code hasn't finished yet because the MSGBOX window is still displayed. This proves that I took this picture while the code was running, not that I turned off the message and took a picture.
@hungt FYI
It's actually a warning message that downloading website content can be harmfull to your computer. Do you wish to continue?
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
@bakerman2, thanks for the info. I always translate from and to English. But in this case I didn't have the patience to guess the words and type them into google translate. If the questioner had provided the text from the dialog box, copy/paste would have been enough.
I translate the allert windows:
avviso di sicurezza WINDOWS
to allow the website to provide personalized information it is necessary to download a small file called a cookie to your computer. download the file?
Last edited by sal21; 07-02-2025 at 11:46 AM.
It's your system, your data,
You should be the one to decide. Don't ask anyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks