Hi =?Utf-8?B?UGF1bCBDaHJpc3RlbnNlbg==?=,
The machine where it works with the message about should it use the converter:
did (or is) an earlier version of Word installed on it?
And was this not the case with the machine that gives "junk"?
MS is in a big "security" to-do. Among other things, all the old converters
that have been around since Word 2.0 or so have been chucked out since the
code is a "black box" and therefore can't be verified/signed as "secure".
There was a lot of discussion about making these available as a separate
download package with a "use at your own risk" warning. But last I heard, it
wasn't certain whether legal questions would prevent this. Making the only
possibility installing the converters from a previous version of Office...
All that being said, I have trouble imagining that VBA which does what you
describe would run into this problem. Word only uses the spreadsheet converter
in the UI if the Insert/File interface is used. But Copy/Paste never does
that. Maybe we need to look at that code and find out what it's really doing?
I have an application that use’s VBA for Word that opens an Excel file in
Word and then cuts & pastes from the Excel data to a Word template. Works fine
in Office 2000. In Office 2003 it works fine on one computer but not on
another. One the that works I get a msgbox asking – This file needs to be
opened by the Microsoft Excel Worksheet text Converter – when I choose
‘Yes’ the file is converted and things work. On the other computer I get
a window ‘File Conversion’. Select the encoding that makes your document
readable. Of chooses available the Excel file is converted to an unreadable
junk.
What am I doing wrong, what settings have I missed?
Both computers using:
Windows XP Pro (SP1)
Office 2003
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.mvps.org/word
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail
