VBA equivalent for Page Break?

[Lauren Quantrell]

I know I can user vbcrlf to generate a linefeed when exporting text.
Is there a way to force page breaks in the exported text using VBA?

[storrboy]

On Apr 5, 8:31 am, "Lauren Quantrell" <[e-mail]>
wrote:

I know I can user vbcrlf to generate a linefeed when exporting text.
Is there a way to force page breaks in the exported text using VBA?

I think page breaks are specific to the program that is viewing the
file or generating the hard copy.
There is a page break control you can use in printing forms and
reports, but I don't know that there is a 'universal' control
character.

[lyle fairfield]

"storrboy" <st******@sympatico.cawrote in news:1175778155.483404.113820
@d57g2000hsg.googlegroups.com:

On Apr 5, 8:31 am, "Lauren Quantrell" <[e-mail]>
wrote:

>I know I can user vbcrlf to generate a linefeed when exporting text.
Is there a way to force page breaks in the exported text using VBA?

I think page breaks are specific to the program that is viewing the
file or generating the hard copy.
There is a page break control you can use in printing forms and
reports, but I don't know that there is a 'universal' control
character.

MS claims that vbNewline is somewhat universal. They also claim that their
programs actually work. So it's a maybe ....

--
lyle fairfield

Ceterum censeo Redmond esse delendam

[storrboy]

On Apr 5, 10:38 am, lyle fairfield <[e-mail]:

"storrboy" <[e-mail] in news:1175778155.483404.113820
@d57g2000hsg.googlegroups.com:

On Apr 5, 8:31 am, "Lauren Quantrell" <[e-mail]>
wrote:

I know I can user vbcrlf to generate a linefeed when exporting text.
Is there a way to force page breaks in the exported text using VBA?

I think page breaks are specific to the program that is viewing the
file or generating the hard copy.
There is a page break control you can use in printing forms and
reports, but I don't know that there is a 'universal' control
character.

MS claims that vbNewline is somewhat universal. They also claim that their
programs actually work. So it's a maybe ....

--
lyle fairfield

Ceterum censeo Redmond esse delendam

I thought that just added a blank line between others. I didn't take
it as a page break. Have to try it sometime.

[lyle fairfield]

"storrboy" <st******@sympatico.cawrote in
news:11**********************@e65g2000hsc.googlegr oups.com:

On Apr 5, 10:38 am, lyle fairfield <[e-mail]:

>"storrboy" <[e-mail] in
news:1175778155.483404.113820 @d57g2000hsg.googlegroups.com:

On Apr 5, 8:31 am, "Lauren Quantrell" <[e-mail]>
wrote:
I know I can user vbcrlf to generate a linefeed when exporting
text. Is there a way to force page breaks in the exported text
using VBA?

I think page breaks are specific to the program that is viewing the
file or generating the hard copy.
There is a page break control you can use in printing forms and
reports, but I don't know that there is a 'universal' control
character.

MS claims that vbNewline is somewhat universal. They also claim that
their programs actually work. So it's a maybe ....

--
lyle fairfield

Ceterum censeo Redmond esse delendam

I thought that just added a blank line between others. I didn't take
it as a page break. Have to try it sometime.

You're right. My bad ... should read the posts before I answer them!
--
lyle fairfield

Ceterum censeo Redmond esse delendam

[Gord]

On Apr 5, 9:02 am, "storrboy" <[e-mail]:

On Apr 5, 8:31 am, "Lauren Quantrell" <[e-mail]>
wrote:

I know I can user vbcrlf to generate a linefeed when exporting text.
Is there a way to force page breaks in the exported text using VBA?

I think page breaks are specific to the program that is viewing the
file or generating the hard copy.
There is a page break control you can use in printing forms and
reports, but I don't know that there is a 'universal' control
character.

In may not be universal any more, but back in the good old days of
line printers the page break character was Chr(12). That is the ASCII
"Form Feed (FF)" character, and the VBA constant is vbFormFeed.

[storrboy]

In may not be universal any more, but back in the good old days of

line printers the page break character was Chr(12). That is the ASCII
"Form Feed (FF)" character, and the VBA constant is vbFormFeed.

I've never bothered looking at that one mostly because of statements
like this from the 2002 (and I pretty sure the earlier ones also) help
file topic called Miscellaneous Constants ....

"vbFormFeed Chr(12) Not useful in Microsoft Windows or on the
Macintosh"

[Lauren Quantrell]

Thanks,
vbFormFeed does the trick, at least for MS Word.
lq
On Apr 7, 7:31 pm, "storrboy" <[e-mail]:

In may not be universal any more, but back in the good old days of
line printers the page break character was Chr(12). That is the ASCII
"Form Feed (FF)" character, and the VBA constant is vbFormFeed.

I've never bothered looking at that one mostly because of statements
like this from the 2002 (and I pretty sure the earlier ones also) help
file topic called Miscellaneous Constants ....

"vbFormFeed Chr(12) Not useful in Microsoft Windows or on the
Macintosh"

[storrboy]

On Apr 8, 9:39 am, "Lauren Quantrell" <[e-mail]>
wrote:

Thanks,
vbFormFeed does the trick, at least for MS Word.
lq

On Apr 7, 7:31 pm, "storrboy" <[e-mail]:

In may not be universal any more, but back in the good old days of
line printers the page break character was Chr(12). That is the ASCII
"Form Feed (FF)" character, and the VBA constant is vbFormFeed.

I've never bothered looking at that one mostly because of statements
like this from the 2002 (and I pretty sure the earlier ones also) help
file topic called Miscellaneous Constants ....

"vbFormFeed Chr(12) Not useful in Microsoft Windows or on the
Macintosh"

Interesting how something branded as "not useful" actually works.