Hacknwhack
Sat Feb 19 16:03:06 CST 2005
Kelly
You need to do something like this
Text:=("&B&""Arial""&16" & CStr(headerstring1)
This sets the font to Arial 16 Bold. You can also use I and U for italic
and underline.
In this example I have defined a var called headerstring1 that contains the
text I wish to display.
-hack
"JackD" <momokuri@gmail> wrote in message
news:uhmVfQfFFHA.624@TK2MSFTNGP15.phx.gbl...
> There were several posts about this in the past week. I didn't read them
> carefully, but there was a resolution I think.
> Try
>
>
http://groups.google.com and do an advanced search for it. (set the
> timeframe for the past 10 days or so)
>
> --
> -Jack ... For project information and macro examples visit
>
http://masamiki.com/project
>
> .
> "KellyB" <KellyB@discussions.microsoft.com> wrote in message
> news:AB200828-13C0-41A0-98BB-BFC4FEE66730@microsoft.com...
> > GREAT!
> >
> > I added a line to add the name of the resource into the header:
> > FilePageSetupHeader Text:="Blah Blah Blah: " & r.Name
> >
> > Unfortunately, this seems to reset the header font to Normal (I had it
> bold
> > and larger font before).
> > Any way that I can set the header font in the code?
> >
> > KellyB
> >
> > "JackD" wrote:
> >
> > > If you are cutting and pasting just snip that out. If you are saving
to
> disk
> > > and "importing" the module you need it.
> > > I'm considering removing that from all the macros and telling people
to
> cut
> > > and paste.
> > >
> > > --
> > > -Jack ... For project information and macro examples visit
> > >
http://masamiki.com/project
> > >
> > > ..
> > > "KellyB" <KellyB@discussions.microsoft.com> wrote in message
> > > news:F1AF66B8-2BA2-49EF-8A44-D30FECBAF708@microsoft.com...
> > > > GREAT!!!
> > > >
> > > > Except:
> > > > The first line of your code: Attribute VB_Name =
> "PrintResourceCharts"
> > > > Gets a syntax error. This line is above the Sub command. Do I need
> to
> > > put
> > > > it somewheres else? What am I missing?
> > > >
> > > > Great Thanks!
> > > > KellyB
> > > >
> > > >
> > > > "JackD" wrote:
> > > >
> > > > > I have one on my site that you can use.
> > > > >
http://masamiki.com/project/macros.htm
> > > > > Look for the "Print Resource Charts" macro near the bottom.
> > > > >
> > > > > --
> > > > > -Jack ... For project information and macro examples visit
> > > > >
http://masamiki.com/project
> > > > >
> > > > > ..
> > > > > "KellyB" <KellyB@discussions.microsoft.com> wrote in message
> > > > > news:A3A149D5-50BB-4FCD-BDFD-D0C950AD9674@microsoft.com...
> > > > > > I'm interested in a macro that will print out a Gantt Chart for
> each
> > > of
> > > > > the
> > > > > > resources - by this I mean that the macro will filter the table
> for
> > > > > "Resource
> > > > > > Names contains etc.", then print setup and change the header to
> > > include
> > > > > the
> > > > > > resource name currently being filtered for, then print.
> > > > > >
> > > > > > I set up a filter that queries for the resource name each time
> > > "Resource
> > > > > > Name:"?, however, when I record the macro, it does not recognize
> my
> > > > > > keystrokes. So if I ran the macro, it would just keep popping
up
> the
> > > > > input
> > > > > > box and I'd have to key the resource name each time. The macro
> should
> > > be
> > > > > > able to cycle through the names in the resource sheet. (I've got
> 45
> > > > > > resources, so printing each individually is a PITA.)
> > > > > >
> > > > > > I've programmed in Excel and Access before, but not Project.
> > > > > >
> > > > > > Please help point me in the right direction - I'd like to
present
> > > these
> > > > > > tomorrow morning.
> > > > > >
> > > > > > Thanks,
> > > > > > KellyB
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>