VBA Project References

[Paul Sansom]

http://www.sansom.co.uk/reference.png

Hi

Can anyone advise me how to remove a reference? This ref is attachedto a specific workbook.
I have tried removing all references to solver in both VBA modules and throughout the workbook and I have removed the SOLVER.XLAM add-in, but the reference persists???? See Reference in image at URL.

Follow up and related question . Is the SOLVER.XLAM add-in in Excel2016 a 3rd party add-in. It seems to be different to the solver being used bymy workbook users in Excel2013?

Any advice or guidance gratefully received... Paul

 

[RoryA]

With the relevant project selected in project explorer in the VBE, Tools-References should show you the list of refererences set for that workbook. Does Solver appear as a checked item?

 

[Paul Sansom]

Hi Rory yes it was checked. unselecting this removed the reference many thanks
what i the effect of removing this ref on a workbook that requires solver? Can I still call this add-in from VBA as

Sub SolverSwithOn()
    
    On Error GoTo Error
    Set Solv = Addins("Solver Add-In")
    If Solv.Installed = False Then
        Addins("Solver Add-in").Installed = True
    End If
    
Error:
    Exit Sub
 
End Sub

 

[RoryA]

That just loads the add-in, so doesn't require a reference. You only need the reference to directly call a routine in the Solver add-in, without using Run.

 

[Paul Sansom]

Excellent news. As very often, excellent and rapid advise. Many thanks very much appreciated.
Paul

 

[RoryA]

Glad to help.