Macros in 2007 are re-formatting my WORD document

[Eric_G]

I had a macro running in WORD / EXCEL 2003 quite well. It extracted data
from an EXCEL sheet and merged the text into a WORD document using bookmarks
to create pre-populated forms.

With WORD 2007, I am finding that the macros are running properly and
calling the proper WORD docx documents, BUT the final WORD documents (post
merge) are not being formatted properly -- the pagination is off and the
documents are no longer printed on a single page. When I compare the
populated documents (using bookmarks) with the initial "templates" into which
I have placed all the bookmarks, the pagination is quite different. There
should not be any changes made to the final documents other than inserting
the data where the bookmark fields have been placed. This never occurred in
WORD 2003. I can't figure out why the layout is changing as the macro is
definitely calling the correct WORD file into which the bookmarks are
properly placed. The macro does not bomb -- only the final pagination is
off.

Any ideas?????

 

[macropod]

Hi Eric,

If you've changed operating systems (or versions), or you've installed a new printer, you're most likely now using different printer
drivers. Word uses the active printer driver to determine the page layout, and that could cause the effects you're seeing.

 

[Eric_G]

Thanks for your suggestion -- so how does one re-set the printer driver
accordingly?

Hi Eric,

If you've changed operating systems (or versions), or you've installed a new printer, you're most likely now using different printer
drivers. Word uses the active printer driver to determine the page layout, and that could cause the effects you're seeing.

--
Cheers
macropod
[Microsoft MVP - Word]

I had a macro running in WORD / EXCEL 2003 quite well. It extracted data
from an EXCEL sheet and merged the text into a WORD document using bookmarks
to create pre-populated forms.

With WORD 2007, I am finding that the macros are running properly and
calling the proper WORD docx documents, BUT the final WORD documents (post
merge) are not being formatted properly -- the pagination is off and the
documents are no longer printed on a single page. When I compare the
populated documents (using bookmarks) with the initial "templates" into which
I have placed all the bookmarks, the pagination is quite different. There
should not be any changes made to the final documents other than inserting
the data where the bookmark fields have been placed. This never occurred in
WORD 2003. I can't figure out why the layout is changing as the macro is
definitely calling the correct WORD file into which the bookmarks are
properly placed. The macro does not bomb -- only the final pagination is
off.

Any ideas?????

.

 

[Graham Mayor]

Unless you have the same operating system in both cases you don't. See
http://word.mvps.org/FAQs/Formatting/TextReflow.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Thanks for your suggestion -- so how does one re-set the printer driver
accordingly?

Hi Eric,

If you've changed operating systems (or versions), or you've installed a
new printer, you're most likely now using different printer
drivers. Word uses the active printer driver to determine the page
layout, and that could cause the effects you're seeing.

--
Cheers
macropod
[Microsoft MVP - Word]

I had a macro running in WORD / EXCEL 2003 quite well. It extracted
data
from an EXCEL sheet and merged the text into a WORD document using
bookmarks
to create pre-populated forms.

With WORD 2007, I am finding that the macros are running properly and
calling the proper WORD docx documents, BUT the final WORD documents
(post
merge) are not being formatted properly -- the pagination is off and
the
documents are no longer printed on a single page. When I compare the
populated documents (using bookmarks) with the initial "templates" into
which
I have placed all the bookmarks, the pagination is quite different.
There
should not be any changes made to the final documents other than
inserting
the data where the bookmark fields have been placed. This never
occurred in
WORD 2003. I can't figure out why the layout is changing as the macro
is
definitely calling the correct WORD file into which the bookmarks are
properly placed. The macro does not bomb -- only the final pagination
is
off.

Any ideas?????

.

 

[Eric_G]

What is most confusing is that the source document (into which the bookmark
field text is inserted) looks fine prior to the 'merge' (as viewed through
NORMAL view) but the merged documents are re-formatted incorrectly. There
has been no change in printers as a result of the upgrade of operating
system.

Hi Eric,

If you've changed operating systems (or versions), or you've installed a new printer, you're most likely now using different printer
drivers. Word uses the active printer driver to determine the page layout, and that could cause the effects you're seeing.

--
Cheers
macropod
[Microsoft MVP - Word]

I had a macro running in WORD / EXCEL 2003 quite well. It extracted data
from an EXCEL sheet and merged the text into a WORD document using bookmarks
to create pre-populated forms.

With WORD 2007, I am finding that the macros are running properly and
calling the proper WORD docx documents, BUT the final WORD documents (post
merge) are not being formatted properly -- the pagination is off and the
documents are no longer printed on a single page. When I compare the
populated documents (using bookmarks) with the initial "templates" into which
I have placed all the bookmarks, the pagination is quite different. There
should not be any changes made to the final documents other than inserting
the data where the bookmark fields have been placed. This never occurred in
WORD 2003. I can't figure out why the layout is changing as the macro is
definitely calling the correct WORD file into which the bookmarks are
properly placed. The macro does not bomb -- only the final pagination is
off.

Any ideas?????

.

 

[Eric_G]

Graham,
Thanks for your suggestion. Unfortunately, the problem persists. It
appears that the STYLES of the source document are being changed once the
macro runs and inserts the data into the bookmarks. The style from NORMAL NO
SPACES to NORMAL is causing some pagination problems. Any idea on why this
formatting change is taking place when bookmarks are inserted?

Unless you have the same operating system in both cases you don't. See
http://word.mvps.org/FAQs/Formatting/TextReflow.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Thanks for your suggestion -- so how does one re-set the printer driver
accordingly?

Hi Eric,

If you've changed operating systems (or versions), or you've installed a
new printer, you're most likely now using different printer
drivers. Word uses the active printer driver to determine the page
layout, and that could cause the effects you're seeing.

--
Cheers
macropod
[Microsoft MVP - Word]


I had a macro running in WORD / EXCEL 2003 quite well. It extracted
data
from an EXCEL sheet and merged the text into a WORD document using
bookmarks
to create pre-populated forms.

With WORD 2007, I am finding that the macros are running properly and
calling the proper WORD docx documents, BUT the final WORD documents
(post
merge) are not being formatted properly -- the pagination is off and
the
documents are no longer printed on a single page. When I compare the
populated documents (using bookmarks) with the initial "templates" into
which
I have placed all the bookmarks, the pagination is quite different.
There
should not be any changes made to the final documents other than
inserting
the data where the bookmark fields have been placed. This never
occurred in
WORD 2003. I can't figure out why the layout is changing as the macro
is
definitely calling the correct WORD file into which the bookmarks are
properly placed. The macro does not bomb -- only the final pagination
is
off.

Any ideas?????

.

.

 

[Graham Mayor]

Change the style set from the Change Styles option on the Home tab to Word
2003 and set as default.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Graham,
Thanks for your suggestion. Unfortunately, the problem persists. It
appears that the STYLES of the source document are being changed once the
macro runs and inserts the data into the bookmarks. The style from NORMAL
NO
SPACES to NORMAL is causing some pagination problems. Any idea on why
this
formatting change is taking place when bookmarks are inserted?

Unless you have the same operating system in both cases you don't. See
http://word.mvps.org/FAQs/Formatting/TextReflow.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Thanks for your suggestion -- so how does one re-set the printer driver
accordingly?

:

Hi Eric,

If you've changed operating systems (or versions), or you've installed
a
new printer, you're most likely now using different printer
drivers. Word uses the active printer driver to determine the page
layout, and that could cause the effects you're seeing.

--
Cheers
macropod
[Microsoft MVP - Word]


I had a macro running in WORD / EXCEL 2003 quite well. It extracted
data
from an EXCEL sheet and merged the text into a WORD document using
bookmarks
to create pre-populated forms.

With WORD 2007, I am finding that the macros are running properly
and
calling the proper WORD docx documents, BUT the final WORD documents
(post
merge) are not being formatted properly -- the pagination is off and
the
documents are no longer printed on a single page. When I compare
the
populated documents (using bookmarks) with the initial "templates"
into
which
I have placed all the bookmarks, the pagination is quite different.
There
should not be any changes made to the final documents other than
inserting
the data where the bookmark fields have been placed. This never
occurred in
WORD 2003. I can't figure out why the layout is changing as the
macro
is
definitely calling the correct WORD file into which the bookmarks
are
properly placed. The macro does not bomb -- only the final
pagination
is
off.

Any ideas?????

.

.