Problems with ChangeLink Command in Excel 2003
I am using the change link command to change the references from one
workbook to another. I have do this a number of times in the code since I am working with different workbooks. For some reason, the command fails on two particular workbooks. The funny thing is that I can manually change the link and then just resume the code, and it all works fine. Any idea why it would fail automatically, but work manually? Thanks, |
All times are GMT +1. The time now is 12:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com