Are you sure that cell C contains the name of an existing file?
If it contains a filename without the directory folder path,
you'll need to use ChDrive and ChDir to set the default folder.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"jim9912" wrote in message
ups.com...
Hi,

THanks so much for helping --

I'm using Office 97 (not my decision - corporate stinginess) so
I used
the object library 8.0, the only option listed in references.

When I run the macro I get the following error:

run time error '4198' command failed

The debugger points to this line:

Set WDDoc = WDApp.Documents.Open(c.Value)



My data starts in cell d5, so I changed

Set rngFiles = Range("A2", Cells(Rows.Count, "A").End(xlUp))

to:

Set rngFiles = Range("D5", Cells(Rows.Count, "D").End(xlUp))

Same error as above.

I'm a vba novice, so forgive me if I'm missing something
obvious.