Equivalent option for Tools->References in Excel 2007

[Saran]

Hi

When I use 2003, I did the following "Tools>References and look in the
Available references list and make sure "ClearQuestOLEServer" is selected".

I couldn't see the option in the Excel 2007, where I can find the above.

Please help me out.

Thanks

Saran

 

[Mike Middleton]

Saran -

In Excel 2003 my Tools menu does not have a References item.

In Excel 2003 Visual Basic Editior my Tools menu does have a References
item.

In Excel 2007 Visual Basic Editior my Tools menu does have a References
item.

- Mike
http://www.MikeMiddleton.com

 

[Gary Brown]

Sounds like you may have had an add-in.
This should do the same....
'==========================================
Public Sub Show_Active_VBE_References()
Dim refReference As Variant
Dim strAnswer As String

On Error Resume Next

strAnswer = "Available References:" & vbCr

For Each refReference In _
Application.VBE.ActiveVBProject.references
strAnswer = _
strAnswer & vbCr & "- " & refReference.Description
Next

MsgBox strAnswer

End Sub
'======================================

 

[Saran]

Thanks Gary

Sounds like you may have had an add-in.
This should do the same....
'==========================================
Public Sub Show_Active_VBE_References()
Dim refReference As Variant
Dim strAnswer As String

On Error Resume Next

strAnswer = "Available References:" & vbCr

For Each refReference In _
Application.VBE.ActiveVBProject.references
strAnswer = _
strAnswer & vbCr & "- " & refReference.Description
Next

MsgBox strAnswer

End Sub
'======================================

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown

 

[Saran]

Thanks Mike.

I got it. Sorry for the wrong info

Saran -

In Excel 2003 my Tools menu does not have a References item.

In Excel 2003 Visual Basic Editior my Tools menu does have a References
item.

In Excel 2007 Visual Basic Editior my Tools menu does have a References
item.

- Mike
http://www.MikeMiddleton.com