I'm trying to use VBA for web scrapping (★ Dream Catcher Home Stay, Cochin, India) and get numerical value for "b_hotel_id" line in the code below
<td class="line-number" value="568"></td>
<td class="line-content">b_hotel_id: '554615',</td>
but I don't know how to refer to it, as there is no...
I have been saving some webpages in a folder on my desktop. The path of this file (the saved webpage in IE) will now be the local folder address. To find the orginal site from which this page was downloaded, this info is available in the "View Source" under
the '< meta property="og:url"...
My level of expertise is copying code and modyifying it to my own purposes. That being said, the code that comes with the userform generated from the Excel "Form" command seems like it would be a desirable thing to have. I'm specifically looking for the code in relation to the command buttons...
Hi All.
For an excel app I'm building I need to (effectively) open a url in internet explorer, select all, and paste onto a sheet... or VBA equivalent. However, I'm not after the source code... I'm after the text that the website visitor would see in their browser. If images etc end up coming...
Hello everyone!
I'm fairly new to Excel and VBA altogether and i got some doubts about VBA.
Right now, i have a worksheet with several cells filled in with info.
What i want to do is go to a website and search for a few strings on the page and if i find them i want to click on the link...
Hi!
I am wondering if there is any good way of coloring different sections of the source code in excel to show what different programmers have added?
Thanks for the help!
I have a file 64,00 rows by 109 columns ~ 4M in size, that contains multiple duplicate entries (~19,000 unique entries). I have the following macro to remove the duplicates but it takes in excess of 2 hours to run. Any idea's on why it is so slow / and or ways to improve its speed. I don't think...
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.