New to VBA
 

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

New to VBA
 

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

New to VBA
 

Dear Jim,

Point taken...thank you.

Ok, i will open these two files:

1. AAA.xls (contains that module), successfully to VLOOKUP all the sheets in
this file.
2. BBB.xls (now i would like to use that module to do Vlookup to this
BBB.xls).

Please guide to to reference "ActiveWorkbook" to the workbook in BBB.xls.

Respectfully,
Andri

"Jim Thomlinson" wrote:

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

New to VBA
 

Try something like

Dim oWB as workbook
'---
Set oWB = Workbooks.open(filename:="c:\data\BBB.xls")
For Each wSheet In oWB.Worksheets
'stuff
Next
oWB.saved = true
oWB.close

HTH. Best wishes Harald

"Andri" skrev i melding
...
Dear Jim,

Point taken...thank you.

Ok, i will open these two files:

1. AAA.xls (contains that module), successfully to VLOOKUP all the sheets
in
this file.
2. BBB.xls (now i would like to use that module to do Vlookup to this
BBB.xls).

Please guide to to reference "ActiveWorkbook" to the workbook in BBB.xls.

Respectfully,
Andri

"Jim Thomlinson" wrote:

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