Get excel workbook and sheet name

[Subz]

The .Application.Caption will display the objects top most window, for example from your previous post $oExcel1 would be Book2 (since it was opened last for $oExcel1), $oExcel2 would be _Excel1.xls - [Read Only] because that was opened last.  If you selected Book3 after the MsgBox, than the top most window for $oExcel2 (all 3 instances) would change to Book3 (although I only write the application.caption for the workbook that has the same name i.e. stringinstr)

Hope that makes sense.

[ahha]

Thanks still testing. 

This is what I initially got when I select a cell in _Excel1.xls.  I was surprised to see no Active Window Title.

---------------------------

---------------------------
Active Window Title:

Active WorkBook: _Excel1.xls

Active Sheet: Tabelle2
---------------------------
OK   
---------------------------

 

When I select a cell in another workbook (not _Excel1.xls) it reverts back to the _Excel1.xls sheet not the one I selected.  Ugh.

*Edit* is this because of the 2 in  $iSearch = _ArraySearch($aWorkBooks, StringReplace($aWinList[$i][0], " - Excel", ""), 0, 0, 0, 1, 1, 2)

 

Here's the code:

expandcollapse popup

#AutoIt3Wrapper_run_debug_mode=Y

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>
#include <Debug.au3>

;Illustrate issue I'm having.  For a user seletecd range (possibly multiple $oWorkbooks open with multiple sheets), I need to determine the Excel application object of the selected cells and the sheet
;I need $oWorkbook, $WorkSheet, $Range
;look at: https://www.autoitscript.com/forum/topic/197347-get-excel-workbook-and-sheet-name/

;Simulate issue - in real world user may have opened Excel and I have no knowledge of the object
$oExcel1 = _Excel_Open()        ;open first instance
_Excel_BookNew($oExcel1)        ;workbook with 3 sheets
_Excel_BookNew($oExcel1)        ;another workbook in same instance with 3 sheets

$oExcel2 = _Excel_Open(Default, Default, Default, Default, True)    ;open second instance
_Excel_BookNew($oExcel2)        ;workbook with 3 sheets
_Excel_BookNew($oExcel2)        ;another workbook in same instance with 3 sheets
_Excel_BookOpen($oExcel2, "C:\Program Files (x86)\AutoIt3\Examples\Helpfile\Extras\_Excel1.xls")    ;open an existing workbook that has been saved so we have an entry in Col2 for full pathname

;now here's what I know without a priori knowledge of the objects
;the workbook names are unigue - that is there will never be a Book1 in any but one of the instances or filename (i.e. single open instance of a particular file)

$aWorkBooks = _Excel_BookList()     ;get an array of all workbooks open
;Success: a two-dimensional zero based array with the following information:
;col 0 - Object of the workbook
;col 1 - Name of the workbook/file
;col 2 - Complete path to the workbook/file
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error listing workbooks.", "@error = '" & @error & "'" & @CRLF &"@extended = '" & @extended & "'")
_DebugArrayDisplay($aWorkBooks, "$aWorkBooks = _Excel_BookList()        ;get an array of all workbooks open.  Col 0 = Object, Col 1 = workbook name, Col 2 = full filename path")
;at this point we have the Object associated with the book name but no full filename path if not saved yet or previously

;now list the sheets for each Object Workbook
For $i = 0 to UBound($aWorkBooks, $UBOUND_ROWS) - 1 ;0 based
    $aWorkSheets = _Excel_SheetList($aWorkBooks[$i][0]) ;Col 0 = Workbook object
    ;Success: a two-dimensional zero based array with the following information:
   ; 0 - Name of the worksheet
   ; 1 - Object of the worksheet
    If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error listing Worksheets.", "@error = '" & @error & "'" & @CRLF & "@extended = '" & @extended & "'")
    _ArrayDisplay($aWorkSheets, "_Excel_SheetList() $aWorkSheets for $aWorkBooks[" & $i & "]" & " Col 0 = Worksheet Name, Col 1 = Worksheet object")
Next

MsgBox($MB_SYSTEMMODAL + $MB_OK, "Info", "Select a range in any Excel instance, any Workbook, and any sheet.  Then click OK.")

;new approach by Subz
ReDim $aWorkBooks[UBound($aWorkBooks)][5]
For $i = 0 To UBound($aWorkBooks) - 1
    $aWorkBooks[$i][3] = StringInStr($aWorkBooks[$i][0].Application.Caption, $aWorkBooks[$i][1]) > 0 ? $aWorkBooks[$i][0].Application.Caption : ""
    $aWorkBooks[$i][4] = $aWorkBooks[$i][0].ActiveSheet.Name
Next
Local $aWinList = WinList()
For $i = 1 To $aWinList[0][0]
    $iSearch = _ArraySearch($aWorkBooks, StringReplace($aWinList[$i][0], " - Excel", ""), 0, 0, 0, 1, 1, 2)
    If $iSearch > -1 Then
        MsgBox(4096, "", "Active Window Title: " & $aWorkBooks[$iSearch][3] & @CRLF & "Active WorkBook: " & $aWorkBooks[$iSearch][1] & @CRLF & "Active Sheet: " & $aWorkBooks[$iSearch][4])
        $oDefaultActiveExcelObject = _Excel_BookAttach($aWinList[$i][0], "Title")
        ExitLoop
    EndIf
Next


MsgBox($MB_SYSTEMMODAL, "Info", "Pause before exit.")

;force close all Excel w/o saving
_Excel_Close($oExcel1, False, True)
_Excel_Close($oExcel2, False, True)

Exit

 

 

Edited January 13, 2019 by ahha
Just tested with a sheet not _Excel1.xls

[Subz]

Sorry forgot to update the second loop it should have been:

MsgBox($MB_SYSTEMMODAL + $MB_OK, "Info", "Select a range in any Excel instance, any Workbook, and any sheet.  Then click OK.")
ReDim $aWorkBooks[UBound($aWorkBooks)][5]
For $i = 0 To UBound($aWorkBooks) - 1
    $aWorkBooks[$i][3] = StringInStr($aWorkBooks[$i][0].Application.Caption, $aWorkBooks[$i][1]) > 0 ? $aWorkBooks[$i][0].Application.Caption : ""
    $aWorkBooks[$i][4] = $aWorkBooks[$i][0].ActiveSheet.Name
Next
Local $aWinList = WinList()
For $i = 1 To $aWinList[0][0]
    $iSearch = _ArraySearch($aWorkBooks, $aWinList[$i][0], 0, 0, 0, 1, 1, 3)
    If $iSearch > -1 Then
        MsgBox(4096, "", "Active Window Title: " & $aWorkBooks[$iSearch][3] & @CRLF & "Active WorkBook: " & $aWorkBooks[$iSearch][1] & @CRLF & "Active Sheet: " & $aWorkBooks[$iSearch][4])
        $oDefaultActiveExcelObject = _Excel_BookAttach($aWinList[$i][0], "Title")
        ExitLoop
    EndIf
Next

 

[ahha]

Subz,

I now get neither working.  Not not even _Excel1.xls.  Could it be the 3 in $iSearch = _ArraySearch($aWorkBooks, $aWinList[$i][0], 0, 0, 0, 1, 1, 3) ?

Here's the full code now.

expandcollapse popup

#AutoIt3Wrapper_run_debug_mode=Y

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>
#include <Debug.au3>

;Illustrate issue I'm having.  For a user seletecd range (possibly multiple $oWorkbooks open with multiple sheets), I need to determine the Excel application object of the selected cells and the sheet
;I need $oWorkbook, $WorkSheet, $Range
;look at: https://www.autoitscript.com/forum/topic/197347-get-excel-workbook-and-sheet-name/

;Simulate issue - in real world user may have opened Excel and I have no knowledge of the object
$oExcel1 = _Excel_Open()        ;open first instance
_Excel_BookNew($oExcel1)        ;workbook with 3 sheets
_Excel_BookNew($oExcel1)        ;another workbook in same instance with 3 sheets

$oExcel2 = _Excel_Open(Default, Default, Default, Default, True)    ;open second instance
_Excel_BookNew($oExcel2)        ;workbook with 3 sheets
_Excel_BookNew($oExcel2)        ;another workbook in same instance with 3 sheets
_Excel_BookOpen($oExcel2, "C:\Program Files (x86)\AutoIt3\Examples\Helpfile\Extras\_Excel1.xls")    ;open an existing workbook that has been saved so we have an entry in Col2 for full pathname

;now here's what I know without a priori knowledge of the objects
;the workbook names are unigue - that is there will never be a Book1 in any but one of the instances or filename (i.e. single open instance of a particular file)

$aWorkBooks = _Excel_BookList()     ;get an array of all workbooks open
;Success: a two-dimensional zero based array with the following information:
;col 0 - Object of the workbook
;col 1 - Name of the workbook/file
;col 2 - Complete path to the workbook/file
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error listing workbooks.", "@error = '" & @error & "'" & @CRLF &"@extended = '" & @extended & "'")
_DebugArrayDisplay($aWorkBooks, "$aWorkBooks = _Excel_BookList()        ;get an array of all workbooks open.  Col 0 = Object, Col 1 = workbook name, Col 2 = full filename path")
;at this point we have the Object associated with the book name but no full filename path if not saved yet or previously

;now list the sheets for each Object Workbook
For $i = 0 to UBound($aWorkBooks, $UBOUND_ROWS) - 1 ;0 based
    $aWorkSheets = _Excel_SheetList($aWorkBooks[$i][0]) ;Col 0 = Workbook object
    ;Success: a two-dimensional zero based array with the following information:
   ; 0 - Name of the worksheet
   ; 1 - Object of the worksheet
    If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error listing Worksheets.", "@error = '" & @error & "'" & @CRLF & "@extended = '" & @extended & "'")
    _ArrayDisplay($aWorkSheets, "_Excel_SheetList() $aWorkSheets for $aWorkBooks[" & $i & "]" & " Col 0 = Worksheet Name, Col 1 = Worksheet object")
Next

MsgBox($MB_SYSTEMMODAL + $MB_OK, "Info", "Select a range in any Excel instance, any Workbook, and any sheet.  Then click OK.")

;new approach by Subz - see his latest entry
ReDim $aWorkBooks[UBound($aWorkBooks)][5]
For $i = 0 To UBound($aWorkBooks) - 1
    $aWorkBooks[$i][3] = StringInStr($aWorkBooks[$i][0].Application.Caption, $aWorkBooks[$i][1]) > 0 ? $aWorkBooks[$i][0].Application.Caption : ""
    $aWorkBooks[$i][4] = $aWorkBooks[$i][0].ActiveSheet.Name
Next
Local $aWinList = WinList()
For $i = 1 To $aWinList[0][0]
    $iSearch = _ArraySearch($aWorkBooks, $aWinList[$i][0], 0, 0, 0, 1, 1, 3)
    If $iSearch > -1 Then
        MsgBox(4096, "", "Active Window Title: " & $aWorkBooks[$iSearch][3] & @CRLF & "Active WorkBook: " & $aWorkBooks[$iSearch][1] & @CRLF & "Active Sheet: " & $aWorkBooks[$iSearch][4])
        $oDefaultActiveExcelObject = _Excel_BookAttach($aWinList[$i][0], "Title")
        ExitLoop
    EndIf
Next

MsgBox($MB_SYSTEMMODAL, "Info", "Pause before exit.")

;force close all Excel w/o saving
_Excel_Close($oExcel1, False, True)
_Excel_Close($oExcel2, False, True)

Exit

 

[Subz]

It works fine for me, can you check that $aWorkbooks Column 3, can match a Window Title in $aWinList Column 0?

 

[ahha]

Here's what I'm getting it looks like what you call Active Window (Application.Caption) is blank.  I'm not sure why I'm using your code from above example.

It appears to be this line: 

$aWorkBooks[$i][3] = StringInStr($aWorkBooks[$i][0].Application.Caption, $aWorkBooks[$i][1]) > 0 ? $aWorkBooks[$i][0].Application.Caption : ""

[ahha]

I've been working in parallel on another variation, and so far this seems to work.

expandcollapse popup

#AutoIt3Wrapper_run_debug_mode=Y

#include <Array.au3>
#include <Excel.au3>
#include <MsgBoxConstants.au3>
#include <Debug.au3>

;Illustrate issue I'm having.  For a user seletecd range (possibly multiple $oWorkbooks open with multiple sheets), I need to determine the Excel application object of the selected cells and the sheet
;I need $oWorkbook, $WorkSheet, $Range
;look at: https://www.autoitscript.com/forum/topic/197347-get-excel-workbook-and-sheet-name/

;Simulate issue - in real world user may have opened Excel and I have no knowledge of the object
$oExcel1 = _Excel_Open()        ;open first instance
_Excel_BookNew($oExcel1)        ;workbook with 3 sheets
_Excel_BookNew($oExcel1)        ;another workbook in same instance with 3 sheets

$oExcel2 = _Excel_Open(Default, Default, Default, Default, True)    ;open second instance
_Excel_BookNew($oExcel2)        ;workbook with 3 sheets
_Excel_BookNew($oExcel2)        ;another workbook in same instance with 3 sheets
_Excel_BookOpen($oExcel2, "C:\Program Files (x86)\AutoIt3\Examples\Helpfile\Extras\_Excel1.xls")    ;open an existing workbook that has been saved so we have an entry in Col2 for full pathname

;now here's what I know without a priori knowledge of the objects
;the workbook names are unigue - that is there will never be a Book1 in any but one of the instances or filename (i.e. single open instance of a particular file)

$aWorkBooks = _Excel_BookList()     ;get an array of all workbooks open
;Success: a two-dimensional zero based array with the following information:
;col 0 - Object of the workbook
;col 1 - Name of the workbook/file
;col 2 - Complete path to the workbook/file
If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error listing workbooks.", "@error = '" & @error & "'" & @CRLF &"@extended = '" & @extended & "'")
_DebugArrayDisplay($aWorkBooks, "$aWorkBooks = _Excel_BookList()        ;get an array of all workbooks open.  Col 0 = Object, Col 1 = workbook name, Col 2 = full filename path")
;at this point we have the Object associated with the book name but no full filename path if not saved yet or previously

;now list the sheets for each Object Workbook
For $i = 0 to UBound($aWorkBooks, $UBOUND_ROWS) - 1 ;0 based
    $aWorkSheets = _Excel_SheetList($aWorkBooks[$i][0]) ;Col 0 = Workbook object
    ;Success: a two-dimensional zero based array with the following information:
   ; 0 - Name of the worksheet
   ; 1 - Object of the worksheet
    If @error Then Exit MsgBox($MB_SYSTEMMODAL, "Error listing Worksheets.", "@error = '" & @error & "'" & @CRLF & "@extended = '" & @extended & "'")
    _ArrayDisplay($aWorkSheets, "_Excel_SheetList() $aWorkSheets for $aWorkBooks[" & $i & "]" & " Col 0 = Worksheet Name, Col 1 = Worksheet object")
Next

MsgBox($MB_SYSTEMMODAL + $MB_OK, "Info", "Select a range in any Excel instance, any Workbook, and any sheet.  Then click OK.")

;from Subz https://www.autoitscript.com/forum/topic/197347-get-excel-workbook-and-sheet-name/
Local $aWinList = WinList()
_DebugArrayDisplay($aWinList, "$aWinList ALL TOP LEVEL WINDOWS")
;~ For $i = 1 To $aWinList[0][0]    ;$aArray[0][0] = Number of windows returned
;~     ;$iSearch = _ArraySearch($aWorkBooks, StringReplace($aWinList[$i][0], " - Excel", ""), 0, 0, 0, 1, 1, 1)     ;original - partial search
;~     If $iSearch > -1 Then
;~         MsgBox(4096, "", "Current WorkBook: " & $aWorkBooks[$iSearch][1])
;~         $oDefaultActiveExcelObject = _Excel_BookAttach($aWorkBooks[$iSearch][1])
;~      MsgBox(0, "Info", "The name of the active sheet is '" & $oDefaultActiveExcelObject.ActiveSheet.Name & "'")
;~      ExitLoop
;~     EndIf
;~ Next

;okay the above does a wrong way partial match when _Excel_BookList() returns
;Row|Col 0|Col 1|Col 2
;Row 4||_Excel1.xls|C:\Program Files (x86)\AutoIt3\Examples\Helpfile\Extras
;and WinList returns
;Row|Col 0|Col 1
;Row 78|_Excel1.xls  [Read-Only]  [Compatibility Mode]|0x001318D4
;
;notice seaching "_Excel1.xls  [Read-Only]  [Compatibility Mode]" for a partial match with "_Excel1.xls"
;it should be looking for "_Excel1.xls" in "_Excel1.xls  [Read-Only]  [Compatibility Mode]"
;so writing our own
For $i = 1 To $aWinList[0][0]   ;$aArray[0][0] = Number of windows returned
    ;$aWinList[$i][0]   ;pull an entry from one row at a time in Col 0 which has the name
    For $j = 0 to UBound($aWorkBooks) - 1
        If StringInStr($aWinList[$i][0], $aWorkBooks[$j][1]) Then   ;found, otherwise go to next row
            ;because of the difference in what _Excel_Booklist() returns we need to keep what WinList returns for attaching
            ;then once we have the object we can just use that
            MsgBox(4096, "", "Current WorkBook: " & $aWinList[$i][0])
            ExitLoop 2  ;exit inner (j) and outer (i) loops
        EndIf
    Next
Next

;we have the current workbook so get other info from $aWorkBooks - recall
;$aWorkBooks[$j][0] ;has object
;$aWorkBooks[$j][1] ;has workbook name
;$aWorkBooks[$j][2] ;has full filename path

MsgBox(4096, "",    "Current WorkBook from $aWinList[$i][0]: " & $aWinList[$i][0] &@CRLF & _
                    "Current WorkBook from $aWorkBooks[$j][1]: " & $aWorkBooks[$j][1] &@CRLF)
;$aWorkBooks[$j][0] ;has object - use this rather than BookAttach since the names are different
MsgBox(0, "Info", "The name of the active sheet is '" & $aWorkBooks[$j][0].ActiveSheet.Name & "'")

MsgBox($MB_SYSTEMMODAL, "Info", "Pause before exit.")

;force close all Excel w/o saving
_Excel_Close($oExcel1, False, True)
_Excel_Close($oExcel2, False, True)

Exit

In either version _Excel_BookList() seems to be really slow.  Is it slow for you?

Edited January 13, 2019 by ahha

[ahha]

Okay further testing done and there appears to be a fundamental problem using WinList - try the following program and you'll see that the Book in Excel is not listed in WinList - UGH   Or am I doing something wrong?

;test of WinList()
#AutoIt3Wrapper_run_debug_mode=Y

#include <Debug.au3>

MsgBox(0, "Info", "Open Excel manually then click OK.")

$aWinList = WinList()
MsgBox(0, "Info", "Try and find the Book in the array that follows.")
_DebugArrayDisplay($aWinList, "$aWinList ALL TOP LEVEL WINDOWS")

 

[water]

Haven't read the whole thread but I would try the following.
This code is untested and might need a COM error handler to grab all COM errors so you can check @Error

#include <Excel.au3>
Global $oExcelTemp, $oExcelWindow
Global $oExcel = _Excel_Open()                      ; Connect to an already started Excel instance
Global $aWorkbooks = _Excel_BookList()              ; Get a list of workbooks for all Excel instances
For $i = 0 to UBound($aWorkbooks) - 1
   $oExcelTemp = $aWorkbooks[$i].Parent             ; Application object for the selected workbook
   $oExcelWindow = $oExcelTemp.ActiveWindow         ; Get active Window for the selected Excel instance
   If IsObj($oExcelWindow) Then                     ; Is there an active window for this Excel instance?
       $oExcelActiveCell = $oExcelWindow.ActiveCell ; Get the active cell of the window
       If @error = 0 Then ExitLoop                  ; If active cell found stop searching
   EndIf
Next

 

[ahha]

I get this error:

 ==> Array variable has incorrect number of subscripts or subscript dimension range exceeded.:
$oExcelTemp = $aWorkbooks[$i].Parent
$oExcelTemp = ^ ERROR

 

I added an ArrayDisplay and it shows

 

Here's the slight mod

#include <Excel.au3>
#include <Debug.au3>
MsgBox(0, "Info", "Open Excel manually then click OK.")
Global $oExcelTemp, $oExcelWindow
Global $oExcel = _Excel_Open()                      ; Connect to an already started Excel instance
Global $aWorkbooks = _Excel_BookList()              ; Get a list of workbooks for all Excel instances
_DebugArrayDisplay($aWorkbooks, "$aWorkbooks = _Excel_BookList()")  ;let's look at it
For $i = 0 to UBound($aWorkbooks) - 1
   $oExcelTemp = $aWorkbooks[$i].Parent             ; Application object for the selected workbook
   $oExcelWindow = $oExcelTemp.ActiveWindow         ; Get active Window for the selected Excel instance
;~    MsgBox(0, "Info",     "$aWorkbooks[$i].Parent = " & $aWorkbooks[$i].Parent & @CRLF & _
;~                      "$oExcelTemp.ActiveWindow = " & $oExcelTemp.ActiveWindow)
   If IsObj($oExcelWindow) Then                     ; Is there an active window for this Excel instance?
       $oExcelActiveCell = $oExcelWindow.ActiveCell ; Get the active cell of the window
       If @error = 0 Then ExitLoop                  ; If active cell found stop searching
   EndIf
Next

 

[water]

My bad. It's a 2D array so the script should look like:

#include <Excel.au3>
Global $oExcelTemp, $oExcelWindow
Global $oExcel = _Excel_Open()                      ; Connect to an already started Excel instance
Global $aWorkbooks = _Excel_BookList()              ; Get a list of workbooks for all Excel instances
For $i = 0 to UBound($aWorkbooks) - 1
   $oExcelTemp = $aWorkbooks[$i][0].Parent          ; Application object for the selected workbook <== MODIFIED
   $oExcelWindow = $oExcelTemp.ActiveWindow         ; Get active Window for the selected Excel instance
   If IsObj($oExcelWindow) Then                     ; Is there an active window for this Excel instance?
       $oExcelActiveCell = $oExcelWindow.ActiveCell ; Get the active cell of the window
       If @error = 0 Then ExitLoop                  ; If active cell found stop searching
   EndIf
Next

 

[water]

BTW: Your debugging statement  won't work as the Parent and ActiveWindow property return an object which can't be displayed using MsgBox.

[ahha]

Thanks for that comment.  So how do I display the text of the parent, active window, and active cell?  I'd like to verify that I've got the correct objects.

[water]

#include <Excel.au3>
Global $oExcelTemp, $oExcelWindow
Global $oExcel = _Excel_Open()                       ; Connect to an already started Excel instance
Global $aWorkbooks = _Excel_BookList()               ; Get a list of workbooks for all Excel instances
For $i = 0 to UBound($aWorkbooks) - 1
   $oExcelTemp = $aWorkbooks[$i][0].Parent           ; Application object for the selected workbook <== MODIFIED
   $oExcelWindow = $oExcelTemp.ActiveWindow          ; Get active Window for the selected Excel instance
   If IsObj($oExcelWindow) Then                      ; Is there an active window for this Excel instance?
       $oExcelActiveCell = $oExcelWindow.ActiveCell  ; Get the active cell of the window
       If @error = 0 Then 
           MsgBox(0, "Result", $oActiveCell.Address) ; Displays the selected cell or the top left cell of a range
           ExitLoop                                  ; If active cell found stop searching
       EndIf
   EndIf
Next

Edited January 13, 2019 by water

[ahha]

I'm trying.  I got this:

So I put $oActiveCell in the Global at top.

Now I get:

0013: 0-0:            MsgBox(0, "Result", $oActiveCell.Address) ; Displays the selected cell or the top left cell of a range
"C:\Program Files (x86)\AutoIt3\AH Code\water's approach v1a_DebugIt.au3" (50) : ==> Variable must be of type "Object".:
MsgBox(0, "Result", $oActiveCell.Address)
MsgBox(0, "Result", $oActiveCell^ ERROR

 

So far not my day but I appreciate all the help.

[water]

I will need to check this tomorrow when I get my hands on a Windows system. Linux with LibreOffice doesn't help much at the moment

[ahha]

water - thanks I really appreciate it.  No rush as I've been working on it for weeks.  What started out (see first post) as what I thought would be simple is, so far, not turning out to be so simple.

[Nine]

A quick question @ahha. Can you tell me what you see in the Excel windows title bar of all your instances.  Since I am on Win7 and using Office 2003, it is a bit hard to figure it out...

[ahha]

Sure.  Here's the 2 instances and what the titles show from running the program.

 

 

[Nine]

Now maximize your books within those 2 excel intances... and show me the titles again !