Insert File - Word 2007

[klav]

In my macro, I am using the insert file command to insert a chart into an
existing document.

The font and spacing change once the chart is inserted into the existing
document. However, if I insert this file into a blank document, this problem
does not occur. Does anyone know why this happens?

 

[Stefan Blom]

A source (inserted) file will always adjust to the settings of the target
document. For example, if text in the source file was formatted in the
Normal style, the definition of the Normal style in the target document
determines the look of that text in the target.

If you want to preserve the formatting of the source, format the text in the
source (inserted) file with direct formatting or, which is better, with
unique styles.

 

[klav]

Thanks for the reply. It would make sense to me if it worked as you suggest.
However, the inserted file is taking on a completely different font and
spacing than what is contained in the target document. Both the file that I
want to insert as well as the target document have times new roman size 12 as
the font. When I perform the insert file command, the font for the inserted
file changes to calibri size 11, line spacing 1.15 with 10 pt after. Any
ideas on why this happens?

 

[Stefan Blom]

Which paragraph styles are being used in the text?

 

[klav]

Ok, you pointed me in the right direction. While the font within the target
document is set to Times New Roman, size 12, the normal STYLE in this
document is set to use the calibri font. Even though in my own personal
normal.dot template the normal style is defined as Times New Roman, I assume
that the normal.dot of whoever created the original document specified
calibri as the default font and that takes precedence over my normal style
definition. Is that the way it works?

 

[Stefan Blom]

Yes, the document styles take precedence over the template styles. The only
way to force the template settings is to set the "Automatically update
document styles" option in the Template and Add-Ins dialog box, but usually
this is not what one wants. See
http://www.shaunakelly.com/word/templaterelations/index.html and
http://www.shaunakelly.com/word/attachtemplate/index.html.

 

[Sally]

Hi, my big problem is the page number for the merged file.
I need to keep the original file page number unchange.
I try to have code to set starting number to 1, but fail.

Can anyone help me? Thanks.

Sally

 

[Stefan Blom]

Place the inserted data in a separate section, by inserting section breaks
in the target document. Then activate the header/footer area (for example by
double-clicking the header). On the Header & Footer Tools Design ribbon,
click Page Number (in the Header /& Footer group), and click Format Page
Numbers. Click the "Start at" option and type the desired starting number.
Click OK.