LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default break excel links


Hello,

IV been trying to break links in excel workbooks by VBA
But I wanted to know how to break all the links in the workbooks, no
just one single link

ActiveWorkbook.BreakLink Name:= _
"\\excel\Portfolios\sample.xls" _
, Type:=xlExcelLinks

This code breaks single link, but is there a code to break them all.

Thanks in advanc

--
striker72
-----------------------------------------------------------------------
striker72s's Profile: http://www.excelforum.com/member.php...fo&userid=2486
View this thread: http://www.excelforum.com/showthread.php?threadid=38406

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Break Links Mr. Clean Excel Discussion (Misc queries) 0 March 2nd 09 06:50 PM
Break Links in Excel 97 CraigH Links and Linking in Excel 1 February 9th 07 05:31 PM
Excel links break on network Salman Setting up and Configuration of Excel 0 September 19th 06 10:30 AM
How to break links Excel 97 jwiley Excel Discussion (Misc queries) 2 December 20th 04 02:49 PM
break links in excel using Office 97 ? piney1643 Excel Worksheet Functions 1 November 12th 04 11:01 PM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"