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!).
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!).