K
Keith
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
(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