E
Ed
I have been dealing with a loop that runs more than 12,000 cycles, and I'm
trying to save some time. Generally, I set a range in a long text file (not
a Word doc), open a new doc from a template, copy the range over, and then
SaveAs the new doc. By far the biggest chuck of time is the SaveAs
function. The only thing I can think of to save time there is to SaveAs a
different file type.
Here's my concern: I do searches through these 12,000+ documents for
certain words or phrases. The VB code that now creates these docs simply
creates a generic text file and tags on a ".doc". Word, though, does not
necessarily recognize all the characters in the doc on a search. I think of
it like running a magnet over parts on a table - aluminum parts, though they
look the same, will not be "found".
So here's my question: I am not dealing with any styles or formatting,
other than a generic monospaced font at 10 point. There are no headers,
footers, bookmarks, graphics, etc. The characters are only letters,
numbers, and basic punctuation - no symbols or special formats. If I use
Word's SaveAs, will I keep the "Word recognition" if I use wdFormatText or
wdFormatEncodedText vice wdFormatDocument? (The text format saved 5 minutes
over the document format when looped through 2,000 docs, which would save
more than half an hour over 12,000 docs!)
Ed
trying to save some time. Generally, I set a range in a long text file (not
a Word doc), open a new doc from a template, copy the range over, and then
SaveAs the new doc. By far the biggest chuck of time is the SaveAs
function. The only thing I can think of to save time there is to SaveAs a
different file type.
Here's my concern: I do searches through these 12,000+ documents for
certain words or phrases. The VB code that now creates these docs simply
creates a generic text file and tags on a ".doc". Word, though, does not
necessarily recognize all the characters in the doc on a search. I think of
it like running a magnet over parts on a table - aluminum parts, though they
look the same, will not be "found".
So here's my question: I am not dealing with any styles or formatting,
other than a generic monospaced font at 10 point. There are no headers,
footers, bookmarks, graphics, etc. The characters are only letters,
numbers, and basic punctuation - no symbols or special formats. If I use
Word's SaveAs, will I keep the "Word recognition" if I use wdFormatText or
wdFormatEncodedText vice wdFormatDocument? (The text format saved 5 minutes
over the document format when looped through 2,000 docs, which would save
more than half an hour over 12,000 docs!)
Ed