Update cells whose source is in a closed workbook

I wish to create a simple macro which will update a range of cells D4:K32.
These cells use a VLookup function to find data in another workbook.
Basically, I want to refresh their numbers since each day, the source workbook may change.
I do not want to have to open to source workbook.

Currently I have this code. Note, the workbook I'm updating cells for is called "Estimates" and the source workbook I have name "file" and is in the directory O:\E\K.

Please Login or Register  to view this content.

This pretty much opens the workbook then presses "Enter" on each cell in Estimates to refresh them.

Is there a better way to do this?

Refresh links?
Using special code which does the same action without the source workbook opening?

Thanks!

Originally Posted by Richard Buttrey

Hi,

Why do you need to do anything at all other than accept and say yes to the links being updated whenever you open the Estimates book?

If you allow the links to update any changes that have been made in the 'file' source workbook will be reflected in Estimates.

Regards

Hi Richard,

My concern was that in the estimates workbook I have a cell where I ask the user to enter a date. From this date, the VLookup searches for the approriate data in the closed workbook, "file".

So changing the date in this cell didn't update the links in estimates since file was closed.

However, I just highlighted all the cells with a VLookup, clicked Edit --> Links --> selected "file" --> Update links

Does this now mean that whenever I change the date in the cell that the VLookups will automatically grab the right data, since they're linked to the closed workbook?
Essentially, I wouldn't need a macro at all if this were the case...

It appears linking the cells works I didn't know this existed until now. I love excel :D