| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
| Can Excel be linked to SAS query | Excel Discussion (Misc queries) | |||
| Query linked cell values | Excel Worksheet Functions | |||
| Counter in a worksheet | Excel Worksheet Functions | |||
| copying files with query(s), the query is still linked to the ori. | Excel Discussion (Misc queries) | |||
Hybrid Mode
