Hi guys,
New to excel macros, but having seen a couple of vids on You Tube I'm quickly becoming fascinated by its potential!
So anyway, there's a task a run every morning and I think a macro could help but i'm hitting huddles. Wonder if anyone can help?
The task
1 - Take 2 csv downloads...
I would appreciate if any super experts would help to find a solution to extract source code data from a chart found on a website and build a macro to automatically import the data to excel. The website's source code is from: Load Forecast vs. Actual: Current Day
The data to extract is the...
I have the following code in my excel module and when I typein this formula =GetURL(A2) (A2 is the cell that the hyperlink in), and press Enter button to see real hidden hyperlink, get the error #NAME?
<code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family...
Hello guys,
I have a column with cells containing html code with various tags, text and various links. Somewhere in these cells there are some hyperlinks of various length from a specific domains
The format of the urls are http://www then followed by a random number, then a specific domain and...
Hello Experts. I just started learning about VBA and got below problem. In below example, column A is a huge set of cells that has strings with URLs in it. I need to extract only URL starting from "http" keyword. There are no cases when this string has more than one URL.
I searched internet...
Hi,
I need to copy the information of all the products of this website:
http://www.selleckchem.com/
but I don't know the url for each individual product. So I need to extract all the url related to the products into excel.
Does anyone know how it can be done?
Many Thanks,
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.