P
Phyl
Hi there,
I'm trying to get a macro to run every time a user hits the Save
button. I want that info to be pushed to the project server when they
do that.
I've looked at PublishInformationOnSave (because I think that's what I
want), but I'm completely flummoxed by how something like this works.
I've tried BeforeSave, Before Close, etc., but apparently I'm just not
getting it. Honestly, I don't understand some of the syntax.
My code currently looks like this:
********************************
Option Explicit
Public Sub auto_close()
SetAvailDates
End Sub
Sub SetAvailDates()
(my macro here)
End Sub
********************************
Now, I've trolled this forum site and I see things like
Project_BeforeSave (ByVal pj as project), but I don't understand what
that means. What is "ByVal" and why do you need to write it? Is
"Project_BeforeSave" the name of the public sub? Is this stuff I need
to publish the information when a user saves?
I'm kind of a newbie at this stuff ... I write VBA code by the seat of
my pants, so any help would be appreciated.
Cheers,
Phyl
I'm trying to get a macro to run every time a user hits the Save
button. I want that info to be pushed to the project server when they
do that.
I've looked at PublishInformationOnSave (because I think that's what I
want), but I'm completely flummoxed by how something like this works.
I've tried BeforeSave, Before Close, etc., but apparently I'm just not
getting it. Honestly, I don't understand some of the syntax.
My code currently looks like this:
********************************
Option Explicit
Public Sub auto_close()
SetAvailDates
End Sub
Sub SetAvailDates()
(my macro here)
End Sub
********************************
Now, I've trolled this forum site and I see things like
Project_BeforeSave (ByVal pj as project), but I don't understand what
that means. What is "ByVal" and why do you need to write it? Is
"Project_BeforeSave" the name of the public sub? Is this stuff I need
to publish the information when a user saves?
I'm kind of a newbie at this stuff ... I write VBA code by the seat of
my pants, so any help would be appreciated.
Cheers,
Phyl