Convert .ole files to .doc

[TonyRobinson]

We have an application which uses .ole files to store free format notes, we need to convert these to Word documents, or better still strip the text out and insert into a database field. Using the OLE container control I can open the .ole files and save as word documents with no trouble, the problem is I have to convert 100,000 files as a small part of an entire system conversion, and it looks as if this will take 30 hours to complete.

I have built in last run date etc, which should reduce the final run time as the vast majority of files will not change, however does anyone know a way of converting .ole files to .docs (or strip the text out) without opening Word each time round the loop. It currently runs slightly slower than 1 per second.

Thanks

 

[Sheco]

Can you just leave the Word application object open and create new document objects for each one?

 

[TonyRobinson]

Yep, already doing that, I think it's the saveas which is taking the time.

I'm currently checking that folders and files exist using FileSystemObject, if I remove this and ensure all possible folders are created prior to running the app and just trap any errors where files don't exist, it may speed things up.