R
Ryan H
I have a Add-In workbook that has code to manipulate data in another workbook
called Quote Generator. Is there a way I can write code to find the
referenced workbooks properties such as .Path and .Name?
For example,
' in Quote Generator workbook
Private Sub Workbook_Open()
' show reference workbooks path
MsgBox ReferencedWorkbook.Path
MsgBox ReferencedWorkbook.Name
End Sub
called Quote Generator. Is there a way I can write code to find the
referenced workbooks properties such as .Path and .Name?
For example,
' in Quote Generator workbook
Private Sub Workbook_Open()
' show reference workbooks path
MsgBox ReferencedWorkbook.Path
MsgBox ReferencedWorkbook.Name
End Sub