VBA Code to update links automatically

Hi,

First of all, thanks to all the gurus in the forum who have greatly improved my programming skills by helping me cross my hurdles.

I have a file for entry of inventory information. This file has links to 4 different excel files. One of the columns in my file is for the current stock quantity. Every time a user completes and entry and starts a new entry, I require a new entry, I require the stock quantity column updated.

What I find is that the links get updated only when my workbook is closed and reopened or the linked workbook is opened and closed.

Is there a macro that will update the links automatically without the linked workbook having to be opened.

There is a menu that does this when the orksheet is unlocked. But I could not get the code when I tried this menu using record macro.

The code has to run in 2003 version also.

Any help will be greatly appreciated.

Anand

To update all links try:

Please Login or Register  to view this content.

To update a specific link try:

Please Login or Register  to view this content.