Linked worksheet Query Counter

  • Thread starter Thread starter Ed Lisay
  • Start date Start date
E

Ed Lisay

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
 
well the workbook it updates links from is not actually
opened, its just linked to and read, does this method take
that into consideration?
 
Back
Top