Subscript out of range - Window object hidden ?

[martindavey]

Hi,
I get subscript out of range on this command.
When I click on Definition for Windows it says Cannot jump to windows because it is hidden. Is this hidden issue relevant I wonder.

Windows("Weekly Sales Template&quot.Activate

Any help appreciated :O)

 

[ide]

no workbook with this name, u miss the caption.

try it to get the right caption:

For i = 1 To Windows.Count
MsgBox Windows(i).Caption
Next i

ide

 

[martindavey]

Cheers, that helped.
The window did exist, it was called :
"Weekly Sales Template.xls"
It depends on the setting of 'hide well known file types extension'

I've changed the code to:

on error resume next
Windows("Weekly Sales Template&quot.Activate
Windows("Weekly Sales Template.xls&quot.Activate


Now it works.