batch print v8i drawings from excel using macro

I've been trying to find a discussion topic or tutorial explaining this step by step.

Here is what I am trying to accomplish:

1. create an excel spreadsheet that has a list of .dgn files for a project

2. use an excel macro to find these drawings, and open them

3. batch print these .dgn files to .pdf and/or plotter using a push button on the spreadsheet

 

Anyone have any suggestions, references?

 

Thanks!