Consulting

Results 1 to 8 of 8

Thread: Loop through all open Workbooks in all Instances

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Tutor
    Joined
    Jun 2005
    Posts
    214
    Location

    Loop through all open Workbooks in all Instances

    Hi fellow programmers,

    Sometimes I need to know which workbooks are active (In all Excel instances). For this I use The code in the attached workbook. At my office we udated our Windows and Microsoft Office versions recently. Nowadays we use Windows 10 and Office 2016. Since this update I noticed that all opened workbooks appear double in different instances. See the printscreen on Blad3 (Sheet3)
    With the previous versions (Windows 7 and Office 2010) I got the wanted and expected results, see the printscreen on Blad2 (Sheet2)
    Does anyone know why this happens?
    To test one and other you may want to create 3 workbooks with, for example, the following names: Test1.xlsx, Test2.xlsx and Test 3.xlsx
    Store these workbooks in a folder and open them. Then execute the code behind the Blue and green buttons.

    Thanks in advance for your time.
    Stranno
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

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