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

your users may not have enabled "Access to VB project
setting in Macro/Security.

this will disable any calls related to vbaproject and it's properties.

on any normal install they WILL have extensibility dll on their
machines, so i doubt that is the real issue.

If other referenes are missing.. then you'll see
standard unqualified VBA methods e.g. Right("string",1 )misbehave.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Mike Molyneaux wrote in


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

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

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

Very good point.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"RB Smissaert" wrote in message
...
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

Thank you very much - works great - only thing I had to change
was to move 'Public VBComp as VBComponent' from Option Explicit to
'dim VBComp as VBComponent' in the routines that used it.

Thanks again
--
Mike


"keepITcool" wrote:


your users may not have enabled "Access to VB project
setting in Macro/Security.

this will disable any calls related to vbaproject and it's properties.

on any normal install they WILL have extensibility dll on their
machines, so i doubt that is the real issue.

If other referenes are missing.. then you'll see
standard unqualified VBA methods e.g. Right("string",1 )misbehave.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Mike Molyneaux wrote in


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