problem referring to another workbooks column

[atray04]

This is actually in reference to some code that xlbo posted earlier. He used this line: For Each c In [Files]
now if the column Files is in a different work book how would I change that? I thought that maybe you could just say wb.Files or maybe activate that workbook and then search the files. Any help would be great thanxs

 

[TonyJollans]

Hi atray04,

If the other workbook is open and called, say, OtherBook.xls, then you should be able to use For Each c In [OtherBook.xls!Files]

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[atray04]

hmmm i tried: For Each c In [FINAL-masterdummy(writable).xls!Files] and i got a type mismatch error

 

[TonyJollans]

Hi atray04,

If your workbook name contains spaces you need to wrap it in quotes ..

For Each c In [

'

FINAL-masterdummy(writable).xls

'

!Files]

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[atray04]

thank you that worked