Might be better to do:
Major:=5, Minor:=0
Otherwise you might be caught out by lower versions.
Or maybe even:
Major:=0, Minor:=0
RBS
"Chip Pearson" wrote in message
...
Try
With ThisWorkbook.VBProject.References
On Error Resume Next
If .Item("VBIDE") Is Nothing Then
.AddFromGuid _
GUID:="{0002E157-0000-0000-C000-000000000046}", _
Major:=5, Minor:=3
End If
End With
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Mike Molyneaux" wrote in
message ...
Is there a way to insure that the Visual Basic for Applications
Extensibility
Library is available when Excel is started.
I'm using Excel 2003 on windows XP Pro with all current updates.
I have sheets that different users use & sometimes it's available &
sometimes not.
Thanks
--
Mike