View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ricardo García Ricardo García is offline
external usenet poster
 
Posts: 3
Default Change path links in Excel from VBA

It's OK, Tom. Thanks

"Tom Ogilvy" wrote:

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?