View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default 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