Hi Rob,
haven't been ignoring you just that this site was down for a few days and secondly I had to figure another way of producing the so-called footer as I wanted more than just a page number, date and time and a file name - which is all EXCEL can give you.
Below is a copy of what I wanted, and have acheived, my footer to look like:
[TABLE="width: 720"]
[TR]
[TD="colspan: 2"]Cartons
[/TD]
[TD="colspan: 2, align: right"]953
[/TD]
[TD][/TD]
[TD]Tubs
[/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[TD="colspan: 2"]Total Weight
[/TD]
[TD="colspan: 2, align: right"]6070.656
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]NO CLAIMS UNLESS RECEIVED
[/TD]
[TD][/TD]
[TD="colspan: 6"]1. Storage details
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]WITIN 48 HOURS OF DELIVERY
[/TD]
[TD][/TD]
[TD="colspan: 6"]2. more storage details
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 18"][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[TD="colspan: 2"]Date of Issue
[/TD]
[TD="colspan: 2"]Customer No.
[/TD]
[TD]Ship To
[/TD]
[TD="colspan: 2"]Phone No.
[/TD]
[TD="colspan: 2"]Order No.
[/TD]
[TD]Terms
[/TD]
[TD="colspan: 2"]Operator
[/TD]
[TD]Run No
[/TD]
[TD]Drop No
[/TD]
[TD="colspan: 2"]Source Doc
[/TD]
[TD="colspan: 2"]Docket No
[/TD]
[/TR]
[TR]
[TD="colspan: 2"]14/03/2011
[/TD]
[TD="colspan: 2"]1002917
[/TD]
[TD]41044
[/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"]3313187
[/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[TD]6061
[/TD]
[TD]10
[/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"]3313187
[/TD]
[/TR]
[TR]
[TD="colspan: 7"]Company Name
[/TD]
[TD="colspan: 3"]Account Instructions
[/TD]
[TD="colspan: 8"][/TD]
[/TR]
[TR]
[TD="colspan: 4"]A.B.N.:99 999 999 999
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD]Paid:
[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Cheque
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Cash
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Total
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 6"]Tub Stocktake
[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Tub Charges____________@_____________
[/TD]
[/TR]
[TR]
[TD="colspan: 9"]Driver Signature
[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Credits____________@____________
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Pallet Charges___________@_____________
[/TD]
[/TR]
[TR]
[TD="colspan: 9"]Customer Signature
[/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Credits____________@_____________
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]*03313187*
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 5"]Tub instructions IN/OUT
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 6"]Customer Name
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"][/TD]
[TD="colspan: 3"][/TD]
[TD="colspan: 6"][/TD]
[TD="colspan: 3"][/TD]
[TD="colspan: 3"][/TD]
[TD][/TD]
[/TR]
[/TABLE]
The "*0331318*" is actually a barcode which prints correctly but doesn't copy and paste so well as you can see.
How did I do this?
Well all I did was to have no footer and to extend the details to print the above after a certain row number had been reached.
Your comment about COM object viewer is oh so true !!!
But I found the MSDN site very useful only it took some time to convert the statements into "Progress-speak".
Regards, and thanks, Barry.