Placing an absolutely positioned image on every printed page

[google]

I have a problem. My office is changing its logo/profile and all
templates needs to be updated. It's a fairly simple layout with the
new company logo as a tif (or eps) placed ~ x:14mm y:7mm from the top
left corner of an A4 sheet. The left margin of the page should be 30mm
(the logo starts within the left margin). When printed as landscape the
logo needs to be rotated 90 degrees and posi-tioned along the right
short side (we want all headers to look the same when the pages are
placed in a folder)

Result: a fairly simple layout, with big problems:

1. The image can't be placed in the header because of the minimum 1
inch "header left margin" default.

2. On a portrait A4 the logo can be positioned in the first row (the
first column has to be left out blank, to compensate for the 30mm left
margin, which isn't very practical) but for landscape this can't be
done as it isn't possible to repeat a column on the right side of the
page.

I'm looking for a macro that places an image exactly x,y from the top
left (or top right when land-scape) of every printed page
(_BeforePrint). Ideally the image needs to be placed outside the
left/right margin. Is it possible to freely place an image outside of
the page margins?

Headaches...

I'm thankful for any help I can get.

deage

 

[NickHK]

The simplest answer is of to get your stationary pre-printed with the
company logo, then it's not a concern. But assuming you have excluded that
....

To me, printing with these requirements in Excel is a hit and miss affair
and printing outside of the margin from Excel will not be possible
Maybe, depending on the header size, would an Image control work ?
You can place it anywhere on the printable area. You would have to replicate
for each page in code.

Or print the .xls to PDF. Edit the PDF, adding the graphic where you want.
Save and print the PDF.
This could be accomplished from VBA with a suitable PDF component and some
research into manipulating PDFs. Adobe Acrobat (not the Reader, but the full
version) should provide this.
You should be able to place the graphic exactly where want.
Whether it eventually prints correct on the out printer will depend on the
printer's limitations, as they all have some regions (top, bottom, left,
right) that they cannot print to.

Otherwise, maybe a printer replacement class will allow you to do what you
need :
http://vb.mvps.org/samples/project.asp?id=PrnInfo

Or possibly using OpenOffice. It can open Excel file, but I have no idea of
its graphics capabilities regarding your requirements.

NickHK

 

[google]

Thanks a lot for the help NickHK,

stationary pre-printed pages are not practical, but it would be a good
solution.

Followup questions:

Maybe, depending on the header size, would an Image control work ?
You can place it anywhere on the printable area. You would have to replicate
for each page in code.

Image Control? Do you mean placing an image in the sheet? Works, but I
don't want to have to copy it for every printed page. Maybe this can be
done with a VBA script upon print?

Or print the .xls to PDF. Edit the PDF, adding the graphic where you want.
Save and print the PDF.

Is an option, do you think it would be possible to merge the excel-pdf
and an eps logo on the fly and then emmediately send to the printer?

Otherwise, maybe a printer replacement class will allow you to do what you
need :
http://vb.mvps.org/samples/project.asp?id=PrnInfo

Will have a look at this...

Thanks again.

 

[NickHK]

If your printer supports Watermarks, that would be easier. Then you do not
need code; just leave it to the printer to add the logo on each and every
page.

NickHK

 

[google]

Thanks for your help everyone.

The best solution turned out to be FinePrint (I'm sure there are other
programs around that do it just as good, just happened to be the first
one we had a look at). I would recommend a similar solution to anyone
hows looking to implement a letterhead on printouts from various
programs, saves the hassle of tweeking every program individually.

I'm still amazed to find out how limited the headers are in excel.

deage