Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > macro event handler requirement
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 9th April 23:44
ndcourt
External User
 
Posts: 1
Default macro event handler requirement


I'm using Project Standard 2003 and trying to write a
macro that uses conditional if statements to determine
whether I continue with the file open or close the
application. I want this to be automated such that I open
a Project file with a script, automatically run a macro,
and if no user interaction occurs within a certain period
of time, close the application.

Does project have any sort of events that can be raised so
that I can use an event handler for a conditional if
statement?
  Reply With Quote


  sponsored links


2 9th April 23:44
jan de messemaeker
External User
 
Posts: 1
Default macro event handler requirement


Hi,

Yes.
The Open event is particularly easy to use
You cna put it in Global.mpt (will fire at every Project opened) or in a
Project
Go into the vBEditor
In the Project explorer select the Global or the Project
In Microsoft Project objects find ThisProject, double-click.
The upcoming window has two drop-down selectors
In teh left one select Project
In the right one select Open
Put the code in teh Private Sub that ccomes up.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"NDCOURT" <anonymous@discussions.microsoft.com> schreef in bericht
news:26d101c4ad03$469985b0$a601280a@phx.gbl...
  Reply With Quote
3 9th April 23:44
ndcourt
External User
 
Posts: 1
Default macro event handler requirement


Thank you for your response.However, it doesn't solve the
problem...

I am already using the Open event you describe below to
run a macro when the file opens. It is after this point
that I have the issue. I want to then determine if a user
has made an input (such as a mouse click) to route further
processing in a conditional statement. If no user
interaction occurs in a given time period, I want the
macro to then take a different conditional statement.


opened) or in a


click.


in bericht

open


period

so
  Reply With Quote
4 9th April 23:44
jan de messemaeker
External User
 
Posts: 1
Default macro event handler requirement


Hi,

A bit long to explain here.
Lookup the article in Help
Using Events with the Application object.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/index.htm
32-495-300 620
"NDCOURT" <anonymous@discussions.microsoft.com> schreef in bericht
news:099701c4ad54$27a724e0$a501280a@phx.gbl...
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666