vba code for changing starting page number

D

dennisv21

I have a 2 page MPP file with a hard page break. I need to number the
first page A-7 and the second page A-8 so they show up in view and on
printed copy.

When using the footer feature, I cannot get different page numbers.
Instead the same page number appears on both pages.

When I set A-&[Page]in footer-center , I get only pages A-1 and A-2.

Does anyone have instructions to write VBA code to make this work for
me?

Thanks!
 
J

Jan De Messemaeker

Hi,

You can insert any of the project summary tasks's text fields in a footer
and those can be set in VBA.
HTH
 
R

Rod Gill

Yeah, I thought of that, but they would be the same for every page. He wants
an automatically incrementing number that doesn't start at 1.


--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Jan De Messemaeker said:
Hi,

You can insert any of the project summary tasks's text fields in a footer
and those can be set in VBA.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
dennisv21 said:
I have a 2 page MPP file with a hard page break. I need to number the
first page A-7 and the second page A-8 so they show up in view and on
printed copy.

When using the footer feature, I cannot get different page numbers.
Instead the same page number appears on both pages.

When I set A-&[Page]in footer-center , I get only pages A-1 and A-2.

Does anyone have instructions to write VBA code to make this work for
me?

Thanks!


--
dennisv21
------------------------------------------------------------------------
dennisv21's Profile: http://forums.techarena.in/member.php?userid=16406
View this thread: http://forums.techarena.in/showthread.php?t=554936

www.techarena.in
 
J

Jan De Messemaeker

Good thinking.
He will have to print a page, change the variable, print another page, etc.
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
Rod Gill said:
Yeah, I thought of that, but they would be the same for every page. He wants
an automatically incrementing number that doesn't start at 1.


--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Jan De Messemaeker said:
Hi,

You can insert any of the project summary tasks's text fields in a footer
and those can be set in VBA.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
dennisv21 said:
I have a 2 page MPP file with a hard page break. I need to number the
first page A-7 and the second page A-8 so they show up in view and on
printed copy.

When using the footer feature, I cannot get different page numbers.
Instead the same page number appears on both pages.

When I set A-&[Page]in footer-center , I get only pages A-1 and A-2.

Does anyone have instructions to write VBA code to make this work for
me?

Thanks!
------------------------------------------------------------------------
dennisv21's Profile: http://forums.techarena.in/member.php?userid=16406
View this thread: http://forums.techarena.in/showthread.php?t=554936

www.techarena.in
 
J

John

Jan De Messemaeker said:
Good thinking.
He will have to print a page, change the variable, print another page, etc.
Greetings,
Jan/Rod,
And that print-change-print process could be automated with VBA just
like Jan mentioned in his initial response.

John
Rod Gill said:
Yeah, I thought of that, but they would be the same for every page. He wants
an automatically incrementing number that doesn't start at 1.


--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


Jan De Messemaeker said:
Hi,

You can insert any of the project summary tasks's text fields in a footer
and those can be set in VBA.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"dennisv21" <[email protected]> schreef in bericht

I have a 2 page MPP file with a hard page break. I need to number the
first page A-7 and the second page A-8 so they show up in view and on
printed copy.

When using the footer feature, I cannot get different page numbers.
Instead the same page number appears on both pages.

When I set A-&[Page]in footer-center , I get only pages A-1 and A-2.

Does anyone have instructions to write VBA code to make this work for
me?

Thanks!
------------------------------------------------------------------------
dennisv21's Profile: http://forums.techarena.in/member.php?userid=16406
View this thread: http://forums.techarena.in/showthread.php?t=554936

www.techarena.in
 
J

Jan De Messemaeker

Thanks John, I must have been particularly unclear when explaining this.

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
John said:
Jan De Messemaeker said:
Good thinking.
He will have to print a page, change the variable, print another page, etc.
Greetings,
Jan/Rod,
And that print-change-print process could be automated with VBA just
like Jan mentioned in his initial response.

John
Rod Gill said:
Yeah, I thought of that, but they would be the same for every page. He wants
an automatically incrementing number that doesn't start at 1.


--

Rod Gill
Project MVP
Visit www.msproject-systems.com for Project Companion Tools and more


"Jan De Messemaeker" <jandemes at prom hyphen ade dot be> wrote in message
Hi,

You can insert any of the project summary tasks's text fields in a footer
and those can be set in VBA.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"dennisv21" <[email protected]> schreef in bericht

I have a 2 page MPP file with a hard page break. I need to number the
first page A-7 and the second page A-8 so they show up in view and on
printed copy.

When using the footer feature, I cannot get different page numbers.
Instead the same page number appears on both pages.

When I set A-&[Page]in footer-center , I get only pages A-1 and A-2.

Does anyone have instructions to write VBA code to make this work for
me?

Thanks!


--
dennisv21

------------------------------------------------------------------------
dennisv21's Profile: http://forums.techarena.in/member.php?userid=16406
View this thread: http://forums.techarena.in/showthread.php?t=554936

www.techarena.in
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top