sending a page break to a word doc from excel via vba

MorningStarFan · Joined: 04 Oct 2007 Posts: 2

Using Miscrosoft office 2003---Does anyone know the syntax for a page break
in vba in excel for a word document?

TIA,
--
MorningStarFan

Archived from group: microsoft>public>vb>syntax

"Jan Hyde · Joined: 04 Oct 2007 Posts: 466

MorningStarFan 's
wild thoughts were released on Thu, 19 Apr 2007 08:20:05
-0700 bearing the following fruit:

>Using Miscrosoft office 2003---Does anyone know the syntax for a page break
>in vba in excel for a word document?
>
>TIA,

Just to be clear, your writting a macro in Excel which
manipulates Word?

As an aside you'll probably get more response from an excel
(or word) group than a VB6 group.

You can usually find your answer by recording a macro in
Word and looking at the code it produces - 9 times out of 10
you'll be able use that code.

MorningStarFan · Joined: 04 Oct 2007 Posts: 2

yes, sorry, I should have but I switch back and forth between two books
looking for vb and vba code ...
Your advise helped by the way. I got the code for the page break from
running a macro on word and looking at the code. It works nicely. Thanks!
Now I'm off to figure out if I can open a table in word from my vba code in
access and insert some text from my access table. Will be cool if I can do it!
Thanks!

--
MorningStarFan

"Jan Hyde (VB MVP)" wrote:

> MorningStarFan 's
> wild thoughts were released on Thu, 19 Apr 2007 08:20:05
> -0700 bearing the following fruit:
>
> >Using Miscrosoft office 2003---Does anyone know the syntax for a page break
> >in vba in excel for a word document?
> >
> >TIA,
>
> Just to be clear, your writting a macro in Excel which
> manipulates Word?
>
> As an aside you'll probably get more response from an excel
> (or word) group than a VB6 group.
>
> You can usually find your answer by recording a macro in
> Word and looking at the code it produces - 9 times out of 10
> you'll be able use that code.
>
>
>

Sending VB6 program output to Excel/Word file Hello, I'm rather new to VB, and didn't manage to find the solution yet, so any help would be very much appreciated! I made a small VB program, that outputs textual data to a textbox. The data consists of numbers (results of calculations) and textual valu

Check if excel and word are installed Hi, What is te quickest way to check if excel and word are installed? Now i use create but thats takes a few second. thanks

Running Word macros from Excel Can anyone out there help out a VB rookie, please? I'm trying to code a routine in a VB script (from MS Excel) that will launch a new occurrence of MS Word, open an existing Word document and then run a macro embedded within that document. I can get as fa

Script, Excel, Word and copy and paste hi i want VB Script to "copy and paste" an image, from an excel cell (pasted and saved to there before manually) to Word. i thought something by using the win clipboard, but i have no idea of the correct syntax and haven't found something anywhere. if som

Sending to printer I have a form with a rich text box on it, i want to be able to click on a button and it print out what is seen in the rich text box, how do i go about this? is there a controller i have to put on the form like you do with common dialog?