Hi all,
Would really REALLY appreciate some help with this.

I'm converting data from a legacy system, one feature was an attachment
option. The legacy application used the VB6.OLE control to store the data
in the database. I need to convert this data back to the original format
for the upgrade.

I retrieve the data and save to a temp file, the load into the VBOLE
container. However, when I use "SaveToFile" it is not saving in the
original format. For example, when I attempt to open a Word document, Word
doesn't understand the encoding. I've used "object.saveas" in the document
and it works great. Problem there, though, not everything is Word. When I
attempt to use "object.saveas" in a spreadsheet, the output is less than
half the size of the original file and Excel won't even throw an error
message.


Thanks very much for any help!

Archived from group: microsoft>public>vb>ole