Macro to get data from website

Nevermore

New Member
Joined
Sep 12, 2013
Messages
12
Hi I have written code to fetch the data from websites but those were just kind of copy paste of the code from internet.

Below are few queries that I have related to the same:

1. What is the basic code required for fetching the data from internet. Like a foundation from where we can customize as per our requirements. I would like to understand the code better and not just a copy paste.

2. Also is there any logic in getting the data by ID or TagName or any other identifier.
The below code will get the data with the help of ID but sometimes I am not able to get the ID so is there any trick or logic to get the data with the help of something else.
Code:
IE.document.getElementById("result_box").innerHTML

3. Is there any function with which I can initiate clicks in the website (eg: making the code click Submit button) also with the help of VB code.

Thanking you all in advance for the help.
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Forum statistics

Threads
1,223,635
Messages
6,173,479
Members
452,516
Latest member
archcalx

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