Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Windows(xxx).Activate statement (Excel 2003)

    Hi

    I have the following statement in my macro

    Windows("Test").Activate

    and it works on some PC's and not others, if I use the following

    Windows("Test.xls").Activate

    It generally works, does anybody know why.

    Regards

    Mike

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Windows(xxx).Activate statement (Excel 2003)

    It has to do with a setting in Windows Explorer. If you hide extensions of known file types (the default setting in Windows), you won't see the extension .xls of an Excel workbook, but it still there. In this situation, both "Test" and "Test.xls" will work. If you don't hide extensions of known file types (this is by far preferable), you'll see the .xls extension, and hence you *must* use "Test.xls".
    So it should always work if you use "Test.xls".

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Windows(xxx).Activate statement (Excel 2003)

    Many thanks Hans

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •