InsertFile - XL - Fails with wd2k, OK in '97

R

RWN

Wd97/NT4 & 2k/Win2kPro

Selection.InsertFile FileName:=PSDir & PSName, Range:="", _
ConfirmConversions:=True, Link:=False, Attachment:=False

Wd97 - Works fine
Wd2k - with ConfirmConversions=False Inserts as text
Made Confirm True and, sure enough, it thinks it's a text file.
Selected XL and the "Command Failed".

Also (perhaps trying to tell me something);
When running under '97 it would pop up a box to allow "Whole Workbook"
(setting the range to a sheet & cell range would kill that).
Doesn't do this in 2k.

File opens fine in XL, directly or from an icon (therefore association
is ok(?)).

Is this a version difference or do I have a bigger problem (besides
being NTB!).
 
R

RWN

Found it.
Tried inserting manually and (lo and behold!) got an error message that
told me I didn't have a feature installed (assuming it was a converter,
though you'd think an Office product would automatically install
whatever's necessary to talk to other Office products (God knows MS has
installed a lot of stuff I didn't want(!)).
Anyway, popped in the CD and all is well.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top