Removing references
Hi I wonder if anyone can help with this. I am trying to use the
following code to remove a reference to a project in VBA so that I can
then close that workbook from with the active workbook.
The code seems to obey all the structures as set out in VBA help but
it, and as many variants as I can try, don't work.
Does anyone know how to do this
Many Thanks in anticipation
Steve
Code:-
Sub remref001()
Dim str001 As Reference
Set str001 = Application.VBE.ActiveVBProject.References(7)
str001.Remove
End Sub
|