ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ActiveWorkbook.BreakLink runs but doesn't work?! (https://www.excelbanter.com/excel-programming/430457-activeworkbook-breaklink-runs-but-doesnt-work.html)

WhytheQ

ActiveWorkbook.BreakLink runs but doesn't work?!
 
I recorded this:

ActiveWorkbook.BreakLink Name:="R:\Statistics\Reporting\Daily Snapshot
Code Book.xlsm", Type:=xlExcelLinks

.....when manually breaking the link everything works fine. When the
above line of code runs it goes through ok but the links don't
actually get broken

Anyone ever experienced this before and got a workaround?

Any help much appreciated
Jason.


All times are GMT +1. The time now is 01:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com