FilePageSetupHeader in Project98

[vb6novice]

I want to change the Center header from code on the Resource Usage sheet just before I print it. I'm looping through an array of filters for work groups and want the work group name to show up i the header for each group. FilePageSetupHeader has no arguments so how do I set the header in code.

All help will be appreciated.

 

[rudo]

Hi,

Maybe I do not understand the question quite well, but it seems to me you can have the code by clicking in Excel on Tools, macro, start new macro, and make a header. You will find the code in vb. (I usually eliminate a lot of code of the page setup.) Between each printout copy change the text of the header in the code.
is that what you meant?

Greetings from holland,

Rudo

 

[vb6novice]

Rudo,

I believe you do not understand. I am working in Microsoft Project 98, not Excel.

I have VBA code which loops through the page setup and sets 10 different filters for the tasls/resources displayed and printed. The MSKB dicusses that the arguments for FilePageSetupHeader were removed for Project 98, but it gave no reason why or what the programmer is supposed to do about that. The end result is that having a call to FilePageSetupHeader in code opens a Page Setup dialog box, which forces me to type or paste text in the header setup for 10 different reports.

I was trying to avoid having user interaction to print the 10 reports.

Thank you for your comments.