activate a window based on date

[simeonmein]

Hi all, I need to activate a window based on a date format and a name.
The codde I used doesn't work in excel 2010, but does in excel 2007?
[CODE]Windows("name" & Format(Date, "ddmm")).Activate[CODE\]
I Need to have it work on both 2007 and 2010. Any help will be great

[Norie]

Why do you want/need to activate the window/workbook?


If you do have you tried something like this?

Please Login or Register  to view this content.

PS You kind of got the code tags upside down, wrong way roundish - the easiest way to add them is to select the code and click the # button on the toolbar above the post window.

[simeonmein]

My workbook activates other workbooks, and then when my main workbook is inactive I get errors, so the code runs before all or any userform is activated to ensure no errors. Its a bit baffeling. Why does the code work in 2007?

[Norie]

Can you post the rest of the code and explain what it's meant to do?

[simeonmein]

Its only a button that calls a userform, its a 2 line code, second line is "userform1.show vbmodeless" nothing tricky. I prefer using single line commands. The code u provided gives me a subscript out of range error.

[Norie]

Is that the same error your original code causes?

[simeonmein]

Jip, but I think if I change the destination of the code to the actual userform that it calls (in the userform initialize), my problem should be solved?

[Izandol]

You may try and include the extension:

Please Login or Register  to view this content.

for example.

[simeonmein]

Good idea, I like ur trail of thought.