Using VBA to alter the font name and size for a footer

[Peter Rooney]

Apologies to Jan, to whom I put this question earlier, but who may not have
seen it yet!

Can anyone provide me with a sample of how to use the font name and size
parameters within a resource Usage view footer

Could you help me out one more time, though - I'm now trying to alter the
font size and name for the footer, but I can't seem to get the &16 and the
&""Impact"" in the right place. This is what I have so far:

FilePageSetupFooter Text:="Resource Usage Print for " & CStr(StartDate) & "
- " & CStr(EndDate) & " Page &[Page] of &[Pages] & [date]"

I realise that this is where the text is defined, but where precisely do I
define the font name &""Arial" and size &36 (for example)

Thanks in advance

Pete

 

[Rod Gill]

Not every action in Project can be controlled via VBA. Record a macro of
you changing the font manually. If it doesn't record anything then you may
not be able to do this.

Another way around the problem is to have a formatted View complete with
correct footer etc. Save it to your Global.Mpt file using Tools, Organizer.
This View will then be available for all your projects. Apply the View then
print.

 

[Peter Rooney]

Rod,

I finally sorted it, with some help from Jan! After much messing around, I
came up with the following which sets the text to 36 point italic underline
bold Impact (how many attributes can I add?)

FilePageSetupHeader Text:=("&I&U&B&""Impact""&36" & CStr(HeaderString))

Thanks again!

Pete

Not every action in Project can be controlled via VBA. Record a macro of
you changing the font manually. If it doesn't record anything then you may
not be able to do this.

Another way around the problem is to have a formatted View complete with
correct footer etc. Save it to your Global.Mpt file using Tools, Organizer.
This View will then be available for all your projects. Apply the View then
print.

--

Rod Gill
Project MVP

Apologies to Jan, to whom I put this question earlier, but who may not
have
seen it yet!

Can anyone provide me with a sample of how to use the font name and size
parameters within a resource Usage view footer

Could you help me out one more time, though - I'm now trying to alter the
font size and name for the footer, but I can't seem to get the &16 and the
&""Impact"" in the right place. This is what I have so far:

FilePageSetupFooter Text:="Resource Usage Print for " & CStr(StartDate) &
"
- " & CStr(EndDate) & " Page &[Page] of &[Pages] & [date]"

I realise that this is where the text is defined, but where precisely do I
define the font name &""Arial" and size &36 (for example)

Thanks in advance

Pete