Thread: Change path links in Excel from VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Change path links in Excel from VBA
ActiveWorkbook.ChangeLink

ActiveWorkbook.ChangeLink "c:\excel\book1.xls", _
"c:\excel\book2.xls", xlExcelLinks

--
Regards,
Tom Ogilvy



"Ricardo García" wrote in message
...
How can I change from VBA the paths for the books and sheets referred in
the
Edit Links Box?




Reply With QuoteReply With Quote