View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default Find Reference Workbook with Code

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
--
Cheers,
Ryan