break links

I would like to create a copy of my large workbook which contains no links. I
am writing a macro in visual basic 6.3 for Excel 2000 and cannot find a
suitable function. Any ideas? Thanks for your help!

"peadar" <peadar@discussions.microsoft.com> wrote in message
news:3EE81117-22FF-414B-9513-63C75328886B@microsoft.com...
> I would like to create a copy of my large workbook which contains no
links. I
> am writing a macro in visual basic 6.3 for Excel 2000 and cannot find a
> suitable function. Any ideas? Thanks for your help!

SaveAs ?

/Fredrik

In xl2002+, there's an option for breaking links.

Edit|links|Break links.

You could copy|paste special|values, but that will remove all formulas--not just
links to other workbooks.

You could use Bill Manville's FindLink addin to have more control. You can find
it here:
http://www.oaltd.co.uk/MVP/Default.htm

peadar wrote:
>
> I would like to create a copy of my large workbook which contains no links. I
> am writing a macro in visual basic 6.3 for Excel 2000 and cannot find a
> suitable function. Any ideas? Thanks for your help!

--

Dave Peterson