I am using MS Access 2000 to open various MS Excel files and make alterations. However, on closing each file it always asks me words to the effect of "do you wish to refresh links?". Is there any way in code to set refresh links to NO rather than have to deal with this question each time while the code is running?
At the minute to close a file I have the following code:
myWorkBook.Close (False)
myApp.Quit
The (False) bit avoids it asking me if I wish to save changes each file.
Any help most appreciated,
Dalein51
At the minute to close a file I have the following code:
myWorkBook.Close (False)
myApp.Quit
The (False) bit avoids it asking me if I wish to save changes each file.
Any help most appreciated,
Dalein51
