Break external Links

Hello all,

Hope you are all good.

I have a problem with the following.

Inside a function i have the following code :

Please Login or Register  to view this content.

The function opens another workbook and then runs this code to change the external links into values. However it does not appear to work.

The function sits in book1.xls and the wookbook it is breaking is wbkname.

Thanks in advance.

My bad i have fixxed this now. was not a problem with this code was a problem somewhere else in he macro.