Activate Word macro via access for multiple .doc's

[newestAF]

I have a word macro used for multiple word documents. These documents are saved as a .bkp from another system. Can't change that. Instead of having to open each individual document, I want to script something (familiar with access mostly) to open the first found document, run macro, close it and move to the next until all the documents are done. Once that's done, I need it to find all the word docs in that folder and delete it. The docs are saved as BK00000000.bkp. The zeros are replaced with various numbers and the amount of numbers varies as well. We're using Office 07 so the application.filesearch won't work. Any suggestions are greatly appreciated.

 

[fumei]

Use the Dir function.

Gerry

 

[newestAF]

Not familiar with that function. Can you point me in the right direction?

 

[SkipVought]

Hi,

Feel free to use VBA Help.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}