Open workbooks update the main one and close the other workbooks

[stojko89]

Hi,

What I'm tryn to do here is ask how can I on 4 different sheet open workbooks that are hyperlinked in cells so it would open the workbook on sheet 1 update the table and close the workbook.
And then move down to the next hyperlinked cell and update the main workbook from the opened one and close it down.
Then move to the next sheet to the next hyperlinked cell and to do the same untill it updated all the tables on all 4 sheets for all hyperlinked cells.
I don't know how to realy ask this...

But I have a code that has named ranges.

Please Login or Register  to view this content.

The hyperlinked cell is one cell above the begining of the named range.
For example for sheet 3 Range D11:D26 the hyperlinked cell is D10
For sheet 4 Range D32:D47 the hyperlinked cell is D31.

The hyperlink cell is the address of where the file is on the computer/server.

My whole code is this:

Please Login or Register  to view this content.

But I'm tryn to make a code like...

Please Login or Register  to view this content.

Any idias?

[stojko89]

My code works now so...
I click on a cell in the named range.
Hit the Update Table button.
It opens the hyperlink and I select the workbook.
It updates and then it closes the workbook.

I know how to avoide the selecting of the workbook I'm tryn to figure out how to tell excel how to do it for every PO number

[stojko89]

Never mind...