View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wes[_5_] Wes[_5_] is offline
external usenet poster
 
Posts: 6
Default Create a reference

Hello,

I recently switched from Excel 2000 to Excel 2003. This
code worked fine in my old version to create a reference
to an add-in file. Can you please tell me what has to be
changed to work in 2003?

Private Sub Workbook_Open()

On Error Resume Next
With ThisWorkbook.VBProject
.References.AddFromFile ("J:\Macros.xla")
End With

Call Restore_Submenu

End Sub


Thanks,
Wes