Log of External Links in the workbook

**DUKE888** · 03-31-2011, 08:40 PM

Hi,

Hope all is well. I have been trying to edit a macro to list out all the external links within the workbook in the tab name "ExternalLinks". The macro lists out Sheet Reference and the cell where the external link is located. But I'm keep on stumbling upon a Run-time error '1004': Application-defined or object-defined error on line If InStr(c.Formula, UserChoice) for the following code.

The macro works if I change c.formula to c.value but that is not the result I'm looking for. Also, it will be an addition if the macro can list out the workbook & the tab named in external link in a separate columns.

Below is the code:

Please Login or Register  to view this content.

Any help is much appreciated.

**broro183** · 03-31-2011, 08:47 PM

Hi Duke888,

Snb's post #6 in the following thread may help you: http://www.thecodecage.com/forumz/me...der-drive.html

hth
Rob

**DUKE888** · 04-01-2011, 01:11 PM

Rob,

Thank you for the prompt response. I have tried the snb macro but doesn't seem to work. I could be wrong in editing the code though.

Regards,
Duke

**snb** · 04-01-2011, 01:35 PM

Please Login or Register  to view this content.

**DUKE888** · 04-06-2011, 10:49 AM

Snb and Rob,

THANK YOU BOTH! I am able to get the desired result. Initially it did gave an error "Object Variable not set" but it was resolved after adding a line to your code "Dim sh as worksheets" and also corrected the "externalLinks" to "ExternalLinks". We only learn through mistakes/ errors/ issues.

I appreciate both of your time for resolving the issue.