Footers...

[louie.warren]

I am supporting a government application. Twice a year, they publish this huge report. The application creates the files in Excel and Word. I then take these files and combine them into a PDF document with Acrobat. The problem I have is, I can't get these footers to be consistent as to positioning between the two tools when I do so. Is there an advanced way to put these footers, in both tools, in very specific places on the page? The format is similar to this:



Date Short title/description of page
Page number
(Date is on the top line on the far left, Short title is on the top line on the far right, and the page number is on the 2nd line on the far right. Don't know if the post will scrub my formatting or not.)

Seems simple, but I need to redesign the ColdFusion code that creates these pages, to place them in the exact same place for each page, regardless of the format (Excel or Word) of the page's file. I've tried everything I can think of, and have come up short each time. The work around, to publish the report on time, has been to align the headers to a grid in Acrobat; rather time consuming.

I posted this here because it involved both Excel and Word and figured double posting in the two different forums wasn't ideal for this question.

Thank you all in advance.

[macropod]

Rather than trying to generate the footers in both Word and Excel, you may do better to insert the Excel data into Word as a table, then simply use Word's own header/footer settings. Excel really isn't designed with the same kind of header/footer control in mind that you find in Word - Excel is more of an analysis and data reporting tool.