Activating an open file with a variable name
What do you want to do when you "go back to oWB? oWB.Activate makes the oWB
file the active file. That doesn't mean that it will be on your screen.
That depends on your code.. What do you want to happen? HTH Otto
"Andyjim" wrote in message
...
I have 2 files open that I need to go back and forth with.
File 1 is defined with a variable name oWB.
File 2 is called Update.xls
When I am in Update.xls and want to go back to oWB, how to I do that?
oWB.Activate doesn't seem to work. Any suggestions would be greatly
appreciated.
Andy
|