Create an addin that will run once a day

[scruffpitt]

Hello,

I have a simple addin that runs when a user opens excel, it will basically pull off information from another excel workbook and create a message box.
What i want however is for this to open only the first time the user opens excel in the morning, not every time during the day.


I was going to do something like

if not cell(blah blah) = date then
message box
cell(blah blah) = date
End if

But i need this to be separate for different users, if I put this so the cell it is matching to is in the workbook its extracting data from it will only run once a day for the first person and not at all for other users.

Is it possible to reference the addin file so i can store information there so it will be separate for each user?


thanks in advance for any suggestions

[AndyLitch]

You could combine the above with the Environ("Username") which returns the windows login ID of the current user... All you need then is a method of recognising whether or not the message has been displayed to that user or not and there are a few ways of tackling that..