break links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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!
Click to expand...

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect Workbook Code Queres 2
Print spreadsheet replacing recipient name 4
A macro that will break a link to another workbood 2
Break links VBA 0
Moving a file from one folder to another 2
sorting numbers as text 7
Macro sends Excel file by Outlook - works in debug - not realtime 4
"Match" function returns wrong value 9

Back
Top