Excel 2000 custom footer is a Word document

[Jeff]

I'm changing the Amortization template to include our
company's legal statement at the end of the printout, a
customer footer.

I've tried editing the customer footer, and hit the
button to create:
&[Path]&[File]

and I'm confused as to what I would insert. I've tried:
&["y:\"]&["LglStmt.doc"]
&[y:\]&[LglStmt.doc]
&"y:\"&"LglStmt.doc"
&y:\&LglStmt.doc

the only thing displayed is exactly what I typed. Is it
possible to embed a Word document as a customer footer,
or must I use scripting ?

thanx
Jeff

[Paul Cundle]

I may have misunderstood the question here but...

Don't change it once you've hit the button. Leave the footer saying
&[Path]&[File] and it will automatically show the path and filename of the
current Excel workbook when printing (and p.preview).

I assume you have XL2k2, since versions prior to that cannot have a dynamic
path/filename in the footer.

The commands are not intended for embedding other files, as this is not
possible.

Paul C,
--

Jeff wrote :

[Keith Hambley]

You may misunderstand what &[PATH]&[FILE] is used for

It will only place the path and file name of the excel worksheet you are
printing as a footer

eg. "c:\My Documents\Sheet1"

The closest I could come to a suggestion for you would be to copy your
policy, paste it into a
cell, then assign the value of that cell as a footer.

Put the following code in the function you feel it would be
appropriate(Workbook.beforeprint possibly)

Worksheets("Sheet2").PageSetup.CenterFooter =
Worksheets("Sheet2").Cells(1, 1)

There is probably a way to embed a word document into an excel sheet and
perform the same thing but
will only try to work that out if it would interest you.

Keith

"Jeff" <jeff_...@hotmail.com> wrote in message
news:02c701c31fd9$fa2b6ca0$a501...@phx.gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.481 / Virus Database: 277 - Release Date: 5/13/2003

[Paul Cundle]

Don't waste cells for temporary information. If you're going for the VBA
approach, use
PageSetup.CenterFooter = ThisWorkbook.FullName

Paul C,
--

Keith Hambley wrote :

[Keith Hambley]

Hmm

I may be misunderstanding what Jeff wanted resolved. But my
understanding of the question was that
he is interested in using the contents of a word document as a footer.

If this is true the statement you have provided wont satisfy his needs.
I was thinking he could
copy the text to a cell and use the code I provided to use it as a footer.
This way he can also change
the text at any time without worring about underlying code.

If all that he wants is to have the name of the workbook as a footer
your method is far better.

Keith

"Paul Cundle" <ne...@cundle.co.uk> wrote in message
news:%23WQkY9I...@TK2MSFTNGP10.phx.gbl...

[Paul Cundle]

I was having a funny moment, there. You're right, he did want a Word doc in
the footer, but because I remember seeing the references to &[Path] etc I
was trying to provide an alternative to that (and I was wrong to do so).
I still believe, though, that if you are going to use VBA to insert a footer
there is no point in putting it in a cell first (a legal statement isn't
likely to change much so could be hard coded).

I suspect it's all rather academic anyway, since trying to put a whole Word
legal statement in an Excel footer seems futile due to length restrictions
and limited formatting control. The only reasonable alternative I can think
of it to programmatically seek the bottom of a document and put the desired
text at the bottom of that page.

[Keith Hambley]

I dont know if we have resolved your issue yet jeff, but here is another
thought .

You can always embed the word document below the last cell that has
information in it.

Keith
"Jeff" <jeff_...@hotmail.com> wrote in message
news:02c701c31fd9$fa2b6ca0$a501...@phx.gbl...