VBA to copy data from website

afrobea_r

Board Regular
Joined
Aug 16, 2015
Messages
76
Dear Excel community,

I have a spreadsheet where I will update periodically, key economic indicators such as manufacturing PMI, GDP growth rate as well as balance of trade for various countries for example.

The data source will be via this website: https://tradingeconomics.com/malaysia/indicators. Malaysia for this example.

I am seeking help for the most efficient VBA to extract the relevant metrics as mentioned above for copy into excel periodically for easy reference and comparison.

Your thoughts and contributions are much appreciated!

Best Regards,
afrobea_r
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
No VBA needed.

Have you tried inserting a Web Data Query?

Data tab on the ribbon, select "From Web", enter the website, pick the table to import, click [Import].

Then to refresh, select Data tab, "Refresh All".
Or, right click in the query, select "Refresh".
Also, right click in the query and pick "Data Range Properties" to select refresh frequency and other options.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,293
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top