• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

MICROSOFT ACCESS 2007

IS THERE A WAY TO ADD A PAGE NUMBER TO A PDF FILE FROM MICROSOFT ACCESS.  I AM EXPORTING MULTIPLE EXCEL FILES INTO ONE SINGLE PDF.  I WOULD LIKE TO NUMBER THE PDF PAGES.
0
centralmike
Asked:
centralmike
1 Solution
 
andreyman3d2kCommented:
I am a bit confused -- you said to add page numbers to a PDF you are exporting from Access, but but then said you are exporting Excel files into a PDF. What exactly are you trying to do, and how is the data flowing?

Andrey
0
 
centralmikeAuthor Commented:
I have ten excel spreadsheets that I had to one pdf file through vba coding.  The excel sheets dont have pagenumbers on them.  When I send the excel spreadsheets to the adobe pdf file it bookmarks each sheet.  I would like to add page numbers to the bottome of each pdf page.
Thanks Mike

0
 
Jeffrey CoachmanMIS LiasonCommented:
The easiest way...?

Put the page numbers in the Excel sheets...
(the page numbers do not show up in the worksheet, only in Print Preview (and the actual hardcopy ))

Office Button-->Print Preview-->Page setup-->Header/Footer
Select Custom header or Custom footer, then click the "Insert page Number" icon.

Then create your PDF's, they should now have the Page numbers.

JeffCoachman
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now