Hi!

I've created a Macro to take data in Excel and convert it to a Word-formatted document.

When I run the macro, Word is launched in the background; and, you really can't do anyting to Excel until it is done. So, I want to add some sort of progress indicator - status bar or text status, it doesn't matter. (Status would be updated at every iteration or every 10 iterations.)

Do I use FORMS for this? Is there something better/different? And, can I update the status while the Macro is reading from Excel and writing to the Word doc?

I do have one Form, which prompts the user to input a filename:
Gen_Help_WordDoc_Form.Show
But, it seems like I have to click "Ok" or "Cancel" to get out and process everything else.

Melissa