ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ChangeLink error (https://www.excelbanter.com/excel-programming/296902-changelink-error.html)

Keith[_7_]

ChangeLink error
 
I am stumped on this one. I am trying to change links in my code
(Excel 97), and am using the command
ActiveWorkbook.ChangeLink file1, file2, xlLinkTypeExcelLinks.

But I keep getting the error...
Method 'ChangeLink' of object '_Workbook' failed.

And I have no idea why! I've looked all over this message board and
the only suggestion I found was to set the TakeFocusOnClick to False.
I did that - still no luck in figuring this one out.

Any other ways that this can be fixed? Thanks!

Keith Crunk


All times are GMT +1. The time now is 09:51 PM.

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