I have a code that logs in to a website as it should but when it goes to click into a drop down menu it errors "Method 'Document' of object 'IWebBrowser 2' failed" and errors on this line IE.Document.getElementsByClassName("MenuBar_Menu")(1).Click
Here is the full code:
Sub test()...
i want get data from web site with following code:
<tbody>
range day
11,670
11,300
price
12,191
11,031
week range
11,739
11,060
year range
11,948
3,999
</tbody>
<tbody>
sharing
20 B
base volume
894,454
floating
17%
vol ave month
9.059 M
</tbody>
i want to export...
For starters, I am relatively new to VBA and adjusted the below code from a former co-workers code that pulled different info. I have looked around for a day or so and finally need the help from the masters.
In col A I have a list of mutual funds and stocks that I need to pull the category...
I have been trying to get my ahead around this, however I do not how to use getElementsByClassName to get this done.
For instance, from the link:
www.cvvillas.com/Destinations/Greece/Kefalonia/Villa-Isicos/Villa-Isicos-Gallery
I need to extract the links of the pictures, 14 of them and copy...
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.