stranno
08-01-2019, 02:37 AM
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
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