• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Get the numbers from a website (IE) using VBA

J

JADANQSC

New Member
Hello All, I would like to know if VBA is able to extract numbers from the following website using IE.
In the website, it will prompt user to select the appropriate dropdown menu (highlighted in yellow) such as the following screenshot1 and to extract the numbers in screenshot2 after the display button is pressed.

Website: https://eservices.mas.gov.sg/statistics/masbills/MASBillsBenchmarkPricesAndYields.aspx

If yes, do you have any samples for me to do it please? :)
Hope to hear from your advices to open the door of enlightenment to me. :)

screenshot 1
1720336606080.png

screenshot 2
1720336666000.png
 
Last edited:
Difficult at the moment:

1720341181553.png

I notice there's a download button; if that downloads a file to your computer would it be OK to grab the data from that file into Excel?
 
Hello !​
JADANQSC said:
do you have any samples
Click to expand...

Web scraping VBA but stuck

Hello Respectable Members, I am trying to web scrape from a page but for that I need to log into an website inside another. I have attached my VBA, if you open the excel an click on macro button it logs me onto the 1st website but then it needs to enter the following information onto the 2nd...
chandoo.org

Web Scraping Help

I am wondering if someone can help me with this. I know very little about this type of VBA coding. I can scrap simple data, but this is a challenge. So here I will say many, many thanks! I have a list of numbers in an Excel spreadsheet and want to loop through them to extract data from the...
chandoo.org
 
p45cal said:
Difficult at the moment:

View attachment 87585

I notice there's a download button; if that downloads a file to your computer would it be OK to grab the data from that file into Excel?
Click to expand...
Hello, the website is up now. After clicking the DISPLAY button (screenshot1), it will bring the user to the list of numbers (screenshot2). It is the number from screenshot2 that I’m interested with.
 
Hello Master Vletm, thank you so much for your prompt response. I'm think my IE browser is unable to apply the [DOWNLOAD] - button. This is why I would need to go to screenshot1 (to select the input from dropdown menu), click DISPLAY to go to screenshot2. The numbers in screenshot2 is what I need to download into a spreadsheet.
could you help me on this please?
A MILLION THANKS to you!!!
vletm said:

JADANQSC​

Did You even test that [ DOWNLOAD ] -button ... ?
It'll give just as You've asked.
View attachment 87587
Click to expand...
 
Last edited:

JADANQSC​

You wrote that ... You think ... so, that means - You've skipped to test it.
I'm using other browsers, I cannot test it with some IE browser myself.
 
vletm said:

JADANQSC​

You wrote that ... You think ... so, that means - You've skipped to test it.
I'm using other browsers, I cannot test it with some IE browser myself.
Click to expand...
I am so sorry for being unclear in my earlier message.
I have tested it using both IE and chrome.
For IE, there is not [DOWNLOAD] -button to click. -Screenshot A
For chrome, there is no response when I click [DOWNLOAD] -button.

Screenshot A
1720371175461.png
 

Attachments

  • 1720371167622.png
    1720371167622.png
    7.3 KB · Views: 2
It would be smoother for You too to give valid information.
I tested it with Chrome and it worked.
Have You checked Your chrome://settings/downloads?
Have You tested any other [ DOWNLOAD ]-options in other sites?
 
vletm said:
It would be smoother for You too to give valid information.
I tested it with Chrome and it worked.
Have You checked Your chrome://settings/downloads?
Have You tested any other [ DOWNLOAD ]-options in other sites?
Click to expand...
Hello Vletm, Yes, I have tested other [DOWNLOAD] - buttons.
Under Benchmark Issues, Auction Data, MAS Bill Issues, I am able to click [DOWNLOAD] - button and retrieve the excel file.
However, it does not work under Historical Prices and Market Indicator.
 
vletm said:
I could get there .csv-file.
Have You verified that there are none .csv-files saved?
Click to expand...
Thanks for your advice! I’m working on the alternative method to retrieve the numbers. In case if I need your advice, I will post it here. :)
 
You must log in or register to reply here.
Back
Top