Which Object libraries should I have?

Eurekaonide

Active Member
Joined
Feb 1, 2010
Messages
433
Dear All

I have a workbook which is linking several items together (within itself) and also automates by pushing things as pictures into powerpoint or word.

I have selected several Object libraries / references within VBE and wonder now if I really need them all? does anyone know from the list below if I could just not have some of them??

Visaul basic for Applications
Microsoft excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Visual Basic for Applications extensibles 5.3
Microsoft office Runtime 1.0 Type Library
Microsoft Windows Installer Object Library
Microsoft PowerPoint 10.0 Object Library
Microsoft Word 10.0 Object Library

(I am running this on version 2002).
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Try to uncheck them all. The VBE will give an error if they cannot be removed.
 
Upvote 0

Forum statistics

Threads
1,224,609
Messages
6,179,879
Members
452,948
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top