View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Paul James[_4_] Paul James[_4_] is offline
external usenet poster
 
Posts: 7
Default opening or activating another workbook file

Ok, that makes sense. But if that's the case, wouldn't we want to put the
On Error GoTo 0 after

wkb.Activate

rather than before it, in case we encounter an error trying to activate it?

This is what would happen if myFile.xls wasn't already open, in which case
we'd want to go to the error handler in "e:".

Paul