View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Andrews Neal Andrews is offline
external usenet poster
 
Posts: 1
Default Excel.ActiveWindow Is Excel.ActiveWindow Returns False

Hi All,

If need to be able to compare Excel Window objects the same as you can in MS
Word (or any other app)

If you do

Excel.ActiveWindow Is Excel.ActiveWindow

in Vba it always returns false, which is clearly incorrect.

It appears that Excel is returning a different object for every returned
Window, thus not allowing Window objects to be compared as they should. Does
any only know how to get a fix on the 'true' Window Object so Windows can be
compared.

Regards
Neal