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: 88
Default Breaking excel links in code?

Anyone know how to break external links from one spreadsheet to
another in Excel. I have used the code
ChDir "C:\Documents and Settings\fdxuser\My Documents
\Flight Loads\"
ActiveWorkbook.BreakLink Name:=FileToOpen,
Type:=xlExcelLinks
But I get an error msg and it doesn't actually break the links...

Thanks,
chet

 
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 07 breaking links LisaK Links and Linking in Excel 11 January 6th 10 06:11 PM
Breaking links in Excel brosull Excel Worksheet Functions 2 June 29th 09 09:38 PM
Excel 2000 breaking links awhyswoman Excel Discussion (Misc queries) 3 June 6th 07 09:04 PM
Breaking Links in Excel 2000 Nevio Excel Discussion (Misc queries) 2 August 17th 05 01:26 PM
How do I prevent my links from breaking in Excel? Excel links Excel Worksheet Functions 1 November 16th 04 05:53 PM


All times are GMT +1. The time now is 12:12 PM.

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"