View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chet Chet is offline
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