Links between workbooks

Hi,
I would like to have a code to update a database, but not just copying and pasting the values, I would like to create a link between the source workbook and the database workbook.
The reason for the link is tha tin the source the user can change a value that affect the values in the database.
I already make the code to update the database, but I just manage to copy and paste values, but not make the link
so I'd really appreaciate your help in this toppic
Many thanks in advance

Hi,

If you wish to link a cell in one workbook to another cell in the other workbook
the the following code will help.

Please Login or Register  to view this content.

It can be put in a loop to link each cell.

HI, many thanks for the suggestion, base on that I made this code, but take ages to run to the end.
Any help or Idea how to speed up?

Please Login or Register  to view this content.

Just an additional information, the problem with this code is that the link is generated cell by cell, so there is anyway to improve that and make the links all at once?
I really appreaciate any help on this
regards

Hi, I made some modifications to the code and now speed is much better.
so if anybody needs to make links between workbooks in a old fashioned way, this code can be used.
If somebody else knows how to do it in a more efficient way, please let me know.
Regards

Please Login or Register  to view this content.