#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Counter

Is there a way to count the # of times a particular
spreadsheet has been open? via VBA or other application? I
need to find out if the reports I'm sending out are being
looked at and analyzed, and not just deleted lol. Any help
would be great.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default Counter

Hi
one way: Put the following code in your workbook module
Private Sub Workbook_Open()
With Sheets(1).Range("A1")
.Value = .Value + 1
End With
End Sub

this increments cell A1 on your first sheet everytime you open this
workbook




--
Regards
Frank Kabel
Frankfurt, Germany

donny wrote:
Is there a way to count the # of times a particular
spreadsheet has been open? via VBA or other application? I
need to find out if the reports I'm sending out are being
looked at and analyzed, and not just deleted lol. Any help
would be great.

Thanks


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Day counter poohgld Excel Discussion (Misc queries) 2 October 2nd 08 10:45 AM
How do i set up a counter? Bulldog21 Excel Discussion (Misc queries) 2 July 23rd 08 02:12 PM
1+2+3+4+........... Counter 23Hitamn Excel Discussion (Misc queries) 3 August 28th 07 10:17 AM
Add A Day Counter EisPanzer Excel Discussion (Misc queries) 3 May 9th 07 01:24 AM
Max value in Do While counter ChrisG[_4_] Excel Programming 7 September 24th 03 01:36 AM


All times are GMT +1. The time now is 09:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"