Break Links and Save as file name in one macro

ghrek

Board Regular
Joined
Jul 29, 2005
Messages
216
Can anyone help??

I have a file which is linked to another book using paste special link. Im trying to create a macro which breaks the links and then saves it in a folder as the file name that Im linking to. I.E I have folders linked to summary 1. Im trying to break the links to summary 1 and then save as summary 1 in another folder.

Can anyone help.

Many Thanks
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Watch MrExcel Video

Forum statistics

Threads
1,118,731
Messages
5,573,889
Members
412,555
Latest member
mark84
Top