lijon
08-21-2009, 12:24 PM
Hey, thanks for reading. I'm trying to write code to switch to another open file.
Typically use something like Windows("Book1.xls").activate
But what if we only had the 1st parts of a filename?
Windows("Ticket" & "*" & ".xls").Activate ...Is what i've tried, but it breaks down and won't switch to the other open book.
Any ideas folks?
Thanks thanks. L
Typically use something like Windows("Book1.xls").activate
But what if we only had the 1st parts of a filename?
Windows("Ticket" & "*" & ".xls").Activate ...Is what i've tried, but it breaks down and won't switch to the other open book.
Any ideas folks?
Thanks thanks. L