Open Microsoft Word and get Page count.
 

I need to some help using Excel to open Microsoft Word. I
have a column that contains file names, I need to search
for this file in one directory, open it in Word and then
get the page count. Once I have the page count I need to
store it in a column in the same row as the file name.
Once this operation is complete I need to go to the next
row and repeat the same operation until I exhaust the file
names.

Has anybody done something like this before?