bobdc.blog

>The macro I wrote yesterday could use some refinement,
>but it works:

thank you for the code

>As far as what to do with the Word XML files once I
>have them, well, don't get me started...

when will you give us another Word XML review? i found the old ones very insightful

greetings

marcelo

Thanks Marco!

>when will you give us another Word XML review?

Let me put it this way: I look hard at certain technology for fun, and at other technology only because it's related to something I'm being paid to do.

Word XML does not fall in the "fun" category.

Hi Bob,

Maybe it's because I already invested about a year of my life into WordML because I was paid to do it (writing for O'Reilly), but I think processing WordML can be fun too. It certainly gives me a lot of tough, real-world problems to try out XSLT 2.0's more advanced facilities on. WordML's format in itself isn't terribly nice in general, and I touched on some of its idiosyncrasies in the Office 2003 XML book, but it does have a certain consistency to it. Also, I've found XML-config-file-driven invocations of xsl:for-each-group to be a very powerful, generic way of reconstituting the hierarchy that's implicit in the relationship of flat lists of paragraph styles.

Evan

"...there are some other options that will be more complex to set up but will run more quickly because they won't require starting up and shutting down the word processor for every document"

TEASE!!! What are these other options? I need to do this on hundreds of files on a regular basis. If you can't write an article on how to accomplish this efficiently, could you drop some breadcrumbs to help me research it further?

Also, many thanks for writing this article; it gets me one BIG step closer to a solution.

Lynwood Hines

Lynwood,

These other methods would involve telling an existing running process to open a file, save it as XML, close it, and then move on to the next file. If you were going to have OpenOffice do this, http://api.openoffice.org would be a place to start, but I would look through and ask questions on the appropriate OpenOffice mailing list before I started serious coding. To do this with Word,

I'm sure there's some VB or C# way to tell a running Word instance to do this, either via COM from outside the instance, or with some macro from inside of Word. For example, the macro might look in a certain directory and convert everything it finds there. As with OpenOffice, I'm sure there's a mailing list out there where you can find people to give you some more specific tips. I haven't done it myself, but this is what would guide my research.

Bob,

Thank you for the quick response. I'll look into the OA api and COM communication approaches first. If I come up with a useful recipe I'll post it back here.

LH

I figured out how to use OLE to tell Word to convert documents to text format. This approach would only require a minor tweak to generate XML, RTF, or any other supported format.

The example below is written in Perl and used the Win32::OLE Perl package:

use Win32::OLE qw(in with);
use Win32::OLE::Const;
use Win32::OLE::Const 'Microsoft Word';

# Instantiate our very own MS Word process:

$wordApp = Win32::OLE->new('Word.Application', 'Quit');

$wordApp->{Visible}= 1; # Set to 0 to hide

# Load "foo.doc" into our instance of MS Word. Terminate with error message if something goes awry:

$wordApp->Documents->Open("foo.doc")
or die("Unable to open Word document: ", Win32::OLE->LastError());

# Save the file as a text file. Delete the destination text file first so we don't have to contend with an overwrite warning window in Word:

unlink "foo.txt" if (-e "foo.txt");

$wordApp->ActiveDocument->SaveAs
({
FileName => "foo.txt",
FileFormat => wdFormatDOSTextLineBreaks
});

# Close document, leave Word running to speed future conversions:

$wordApp->ActiveDocument->Close();

# When you are finished doing conversions, kill the word instance:

$wordApp->Quit;

Looks great, thanks!