Excel GetObject - path unknown

[hotbread]

I need to reference a workbook that is open on the desktop, but the path is unknown. Is there anyway to use the GetObject to reference a workbook based on it's name instead of the full path?

The macro can't do this by looking through the Workbooks collection because the open workbook is usually in a different instance of Excel from the one the macro is running from.

 

[CaptainD]

Use "Alt"-"F11" to open the VBA editor and in the workbook open event enter this (Or some other means to fire an event, macro or ??

See if that will work.

Private Sub Workbook_Open()

MsgBox Me.Path & "\" & Me.Name

End Sub

End Sub

 

[JerryKlmns]

GetObject shall grabe the instance of excel running, so play with the names of open workbooks to find yours.