VBA Code to Open Webpage, Select All, Paste to Excel

[amonty78]

Hi all,

I'm trying to create a simple VBA code that will open up a web link that as text (not hyperlink) I have in cell A1, select all data on the web page, then paste to the workbook (Sheet1, cell b1), pasting as "Match Destination Formatting".
I've tried google for the answer but I'm not very experienced with VBA and hence not getting very far.

Any help would be appreciated.
Thanks !

[alansidman]

Are you still running Excel 2003 or a later version. If a later version, please update as that will make a potential difference in a solution.

[amonty78]

I'm running the latest version at 64-bit, thanks.

[alansidman]

Please update your profile to reflect the current version you are running. It makes a big difference in how people answer your needs as newer versions have features that the older versions do not. Will relook at your needs and will try to find a solution.

Also, are you able to share a web site that you are looking to import for? And what data do you want from that site?

[amonty78]

Thanks for the feedback. I've changed my profile.

Here is an example of the webpage(s) I will be trying to grab data from :

https://racing.hkjc.com/racing/infor...se=ST&RaceNo=1

Currently my manual process is to open the page in Internet Explorer, click Ctrl+A, Ctrl+C the paste into Excel (Match Destination Formatting). So I'm trying to come up with some VBA code that will automate this process. Once I have the basic code, I should be able to amend it to reference whichever different webpage I need.

Hope this makes sense.....thanks.

[alansidman]

Using Power Query/Get and Transform you should be able to open the web site and download the tables and then load them to your spreadsheet. If you have not used PQ, click on the links regarding PQ that are in my signature block in my first post in this thread. You can manipulate the data that you down load in PQ if needed.

[amonty78]

I'll check it out thanks.