url hyperlink

Fellow sufferers My below code stalls somewhere between Debug.Print "Inserting pic from URL " & strShpUrl and Debug.Print "Inserted pic from URL " & strShpUrl. I am new to errorhandling, I tried to read everything there is, so whats wrong with my code? The sub should be run about 300 times to...

I have a workbook that has a column which contains the titles of different documents which are published to a website (B4:B6). Another column contains the URLs for those documents (C4:C6). <tbody> Document Title External Link How to Eat Worms www.fakewebsite.com/how-to-eat-worms How to Dig...

I am having a problem pulling a URL that is generated in one area of a spreadsheet 'particular cell' and using it in some VBA code, Typing the URL into the VBA statically works fine, but I dont seem to be able to get the VBA to use the generated URL :confused:

Hi, I'm a long time reader but first time poster. I've spent a long time googling and am hoping someone can help me. My problem: I want to open a specific URL from Excel. The issue is that the URL needs to be opened exactly - I'm using a specific gmail URL string which won't work if it's...

Hi All I'm trying to convert a url link to an to show the image in excel. My url is in column J and I would like the image in Column K. I would also like the image to be 81 x 81 in size. Can anyone help me with this. Im running Excel 2016 for mac. Cheers

Hello and thanks in advance. I'm trying to collect email addresses from a bunch of different pages on a web domain and paste it in excel 2013. I'd like the macro to: find the email address on the web page (i have a list of 1,100 hyperlinks in Column A), copy it, and paste it in Column H, for...

I have an excel workbook with hyperlinked cells that point to .pdf files located in various folders on my company network. I would like to be able to create a macro that will allow me to select a range of cells (containing hyperlinks) and save copies of the associated .pdf files to the current...

Hi, if in field, I have value with hyperlink. I'm removing the value and put it just hyperlink example: A1 = "MREXCEL" where MREXCEL is link into "MrExcel.com | Excel Resources | Excel Seminars | Excel Products" after macro I get only the link: A1 = "MrExcel.com | Excel Resources | Excel...

I have a spreadsheet that lists product data. Each row item (individual product) lists a unique ID. At the end of each row item, I have used a hyperlink formula to create a url.... EX: =HYPERLINK("http://www.example.com/product.aspx?ID="&F3&"&target=ts2", ""&A3&"") In the formula above, F3 is...

I have a list of 5,000 urls and I'd like to see what the actual url that is returned for each of them. For example, if I run the url www.example.com/runningshoes, that url may redirect to www.example.com/shoes. I'd like to see what each url returns. Is there a formula/macro that I can use to see...

If A1 = John B1 = Bloggs<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> How do I make C1 = a hyperlink to a file in the format "D:\files\John Bloggs" which I can then click to access John Blogg's files.<o:p></o:p> <o:p></o:p> I got as far...

I wish to use a formula to grab data out of cells A1 & B1 and use that data to complete a hyperlink URL in cell A3. The base URL never changes but the last two variables do. For instance: URL Format: http://www.test.com/XXXX&page=XXX Example data: Cell A1 = 1234 (always 4 digits) Cell A2 =...