Macropod,

I was able to figure out the problem, but now the excelsheet doesn't load the data in the word doc. The word doc appears for few seconds and closes.

Quote Originally Posted by Bill70
Hello Macropod,
I am new to macro and I am using you code to extract data from a word document. But, "wdApp As New Word.Application" is highlighted" and I get the following error: "User-defined type not defined"
Any idea what the problem is?

I am using MS Office Pro 2010