Dear All,

Please help..i have the module like this:

For Each wSheet In ActiveWorkbook.Worksheets....it works when the file is
open.

How to replace "ActiveWorkbook" with the closed file for this details:
c:\data\AAA.xls.

thank you for your kind attention and help.

respectfully,
Andri