• 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

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 !​
do you have any samples
 
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?
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!!!

JADANQSC

Did You even test that [ DOWNLOAD ] -button ... ?
It'll give just as You've asked.
View attachment 87587
 
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.
 

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.
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: 0
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?
 
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?
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.
 
I could get there .csv-file.
Have You verified that there are none .csv-files saved?
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. :)
 
Back
Top