Wd97/2k->'03 - Insert File Problem

[RWN]

Converting template that worked well under both '97 & 2k (under NT and
2kPro resp) to wd'03 on XP network.
Macro gets a sheet from an XL workbook and inserts it into the document
(a rate table).

The offending statement is;
With Selection
.InsertFile FileName:=PSDir(0) & PSName, Range:="conrate!", _
ConfirmConversions:=False, Link:=False, Attachment:=False
End With
(The "Range" is the sheet name in the workbook.)

Problem - errs out w/message "Bookmark not found". I have determined
that it's objecting to the Range parameter.

Has something fundamental changed in '03 vs. 97/2k, or have I been
"lucky" so far?
Couldn't get a hint (that I could see) from Help and the content of the
Help screen hasn't changed between versions.

Hints?

 

[Word Heretic]

G'day "RWN" <[email protected]>,

Mate, I'm just guessing here, but I think you've been lucky so far
From memory you insert the filename like

Path/Filename#Worksheet

and it works ...

Have a snoop around in that direction and you might get lucky.

Steve Hudson - Word Heretic
Want a hyperlinked index? S/W R&D? See WordHeretic.com

steve from wordheretic.com (Email replies require payment)


RWN reckoned:

 

[RWN]

Thanks.
I have since discovered that the problem is that it appears as though the
Excel converter is missing in (our) version of Wd'03(?)
Found out by attempting to manually insert the file and all worked to the
point of selecting the converter (XL not listed even though the "range" box
"understood" it to be an xl workbook).
I've posted the problem (and nasty details) on the Word.Conversions ng to
see if I can get some guidance.