New to VBA

A

Andri

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
 
J

Jim Thomlinson

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...
 
A

Andri

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
 
H

Harald Staff

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
 
Top