That does not work with a closed workbook. While there are some techniques to
deal with closed workbooks they generally require that you know the structure
of the workbook. You can not just traverse all of the sheets. You need to
reference them one at a time by index number of name.

My recommendation is to open the workbook...
--
HTH...

Jim Thomlinson


"Andri" wrote:

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