View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Break Links Macro help...

Hi mydogpeanut

In this macro you can see how to open the workbooks
http://www.rondebruin.nl/copy4.htm

Then instead of the copy code you can use code from this page to break the links
http://www.rondebruin.nl/values.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"mydogpeanut" wrote in message ...
Hello,

I need to write a Macro that will open up several workbooks (not all at
once), break all links and then save the workbook and then close it back
down.

Can anyone help me?

Thanks so much!!