I appreciate it. I meant to say I was using VB.NET to accomplish this but I
believe the base logic will remain the same.
What is the best way to set the Text Box at the bottom with VB.NET? I think
I am missing something particular in my code or I am making it too
difficult.
Nick was telling us:
Nick nous racontait que :
> I appreciate it. I meant to say I was using VB.NET to accomplish
> this but I believe the base logic will remain the same.
Sorry, mu crystal ball was at the cleaners! ;-)
> What is the best way to set the Text Box at the bottom with VB.NET? I
> think I am missing something particular in my code or I am making
> it too difficult.
Again, the easiest would be to create a style with a frame and then apply
that style to the target text. It will automatically be placed were you want
it(according the frame settings).
Otherwise, look up the Top and Left properties of the Shape object (A
textbox is a Shape).
Not sure abut the exact VB.Net code... I have only used VB Classic...

Signature
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org
Nick - 07 Dec 2006 19:26 GMT
Thanks again.
Can I ask what you would do in VB Classic? I can play around with it and
see what I can figure out but I thought it wouldn't hurt asking.
I think a template could make this a little easier.
> Nick was telling us:
> Nick nous racontait que :
[quoted text clipped - 16 lines]
>
> Not sure abut the exact VB.Net code... I have only used VB Classic...
Jean-Guy Marcil - 07 Dec 2006 19:31 GMT
Nick was telling us:
Nick nous racontait que :
> Thanks again.
>
> Can I ask what you would do in VB Classic? I can play around with it
> and see what I can figure out but I thought it wouldn't hurt asking.
Using the complicated text box approach or the easy frame solution?
> I think a template could make this a little easier.
???
I thought you had a template.
What are you trying to do?
Why can't you use a template?

Signature
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org
Nick - 07 Dec 2006 19:46 GMT
I can use a template but I was trying to avoid it :)
In a nutshell, I'm fetching data from a DB and since I don't know how much I will have and I need particular data at the bottom, I have to force it there no matter the DB result.
I'm open to suggestions on geting it most efficient.
Jean-Guy Marcil - 07 Dec 2006 21:04 GMT
Nick was telling us:
Nick nous racontait que :
> I can use a template but I was trying to avoid it :)
Why?
> In a nutshell, I'm fetching data from a DB and since I don't know how
> much I will have and I need particular data at the bottom, I have to
> force it there no matter the DB result.
>
> I'm open to suggestions on geting it most efficient.
Using a template will make your life much easier.
Create a template formatted for receiving the DB stuff.
In that template, create a style using a frame for the stuff you want at the
bottom of the last page.
Create a document based on the template.
Insert the DB stuff
Insert the text that should go at the bottom and apply the Frame style to
that text.
Dim rgeBottomText As Range
Set rgeBottomText = ActiveDocument.Range
With rgeBottomText
.Collapse wdCollapseEnd
.InsertAfter "New Text"
.Style = "Heading 1"
End With

Signature
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org