I have a list of URLs - one per cell. How can I use a web query (or anything) to pull in each URLs page title? I'm using Excel 97, but I could also do this on 2000 if need be. Thanks.
Afraid it's been a while since I took a VB class (and that was VB6). Let's say I have URLs in cells A1-A10. I'd like to be able to grab the page titles from those URLs and put them next to the URLs into cells B1-B10. How do I go about doing this?
My code will pull all the data from each web page that the link points to! So you will get a full sheet worth of data for each link, if you add a loop to automatically search each link?
Are you looking to convert a link from it's numbers to it's string name?
Or, are you wanting to pull a line of text off of each page or something?
For example, if I had "http://www.thecatsite.com" in cell A1, I would like to be able to pull the page title, which is "TheCatSite.com - Home," into cell B1, and so on.
Each web page may have different strings in different places that indicate its name. To do a text search you will need the exact location of the text you want to locate and report.
The code below will report all the generic info contained in the URL.
To work it go to the cell under your link then run the code:
Sub HlinksA()
'List all of the selected hyperlinks properties!
'Note: Select a cell next to the H-Link & use the cursor to slide into its cell.
'Then run this code to show that links properties!
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.