Linked worksheet Query Counter
 

Todd,

Not sure if I am understanding what you are trying to do.
I assume both workbooks can access each other, and you
want one workbook to know the number of times the other
one was openned. If that is the case, you could put the
following in the Workbook_Open event of the one you want
to know how many times it was openned:
Range("A2").Value = Range("A2").Value + 1
(Replace A2 with a cell that is not being used.)
You could then use the value in the other workbook.

Hope that helps,
Ed

Linked worksheet Query Counter
 

well the workbook it updates links from is not actually
opened, its just linked to and read, does this method take
that into consideration?
-----Original Message-----
Todd,

Not sure if I am understanding what you are trying to do.
I assume both workbooks can access each other, and you
want one workbook to know the number of times the other
one was openned. If that is the case, you could put the
following in the Workbook_Open event of the one you want
to know how many times it was openned:
Range("A2").Value = Range("A2").Value + 1
(Replace A2 with a cell that is not being used.)
You could then use the value in the other workbook.

Hope that helps,
Ed

.