ExcelBanter - Change path links in Excel from VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change path links in Excel from VBA (https://www.excelbanter.com/excel-programming/344228-change-path-links-excel-vba.html)

Ricardo GarcÃa

Change path links in Excel from VBA

How can I change from VBA the paths for the books and sheets referred in the
Edit Links Box?

Tom Ogilvy

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?

Ricardo GarcÃa

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?

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