Hi,
I have a macro that generate a Word document from Excel with a progress bar
indicator. I have another Excel file (main file) that can create Word report
one by one by opening an excel file #1, create the report #1, opening excel
file #2, word report #2, etc. During this process, I would like to indicate
the progress bar of the file #1. #2, ... inside the main excel file progress
bar.
Thank you!
Alex

File #1 33%, 34%, 35%, etc.
File #2 0%
File #3 0%
I have a macro which is called "ExecuteReport" inside "Thisworkbook" class
module which is executed from the main excel file like:
Dim wb As Workbook
Load UserForm1 'ProgressBar
UserForm1.Show
For Each wb in ...
Set wb = Workbooks("File #i.xls")
wb.Executereport 'Is there a way to update Userform1 ProgressBar during
the production of the word document. (takes 2 minutes to do!)
set Wb = Nohting
Next wb

--
Alex St-Pierre