index > Visual Basic for Applications (VBA) > How can I modify the "Available References" list from V...

How can I modify the "Available References" list from V...


Does anybody know how I can modify the list of "available references" from VBA?
Some documents contain old relations causing errors during automated processing.
Therefore I would like to scan this list for unused elements and remove them automatically.

Any ideas?

NetDiver
NetDiver

Hi,

You should be able to do using the VBProject object. You need to reference Microsoft Visual Basic For Appilcations Extensibilty objects. The VBProject object has a References collection that I'm presuming will let you edit and change the list of references of a project.

If you do searches include VBIDE as thats the collective name of the objects in Microsoft Visual Basic For Appilcations Extensibilty library.

If you get it working post the code if you can I'd like to see how it's done. That would be quite interesting.




www.dsmyth.net/blog
Derek Smyth

here's a link that might be useful

http://www.cpearson.com/excel/vbe.htm




www.dsmyth.net/blog
Derek Smyth
reply 3

You can use google to search for other answers

 

More Articles

• How to refer to an object by the tab index
• insert column after pivot table
• Output Parameter in Excel VBA
• Where is the command button on microsoft visual basic
• How Can Write in Data Grid
• Adding a table column using VBA in Access
• email from excel
• No Database Type
• Runtime error '-2147467259(80004005)';
• Selection of only one object
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

• How can I modify the "Available Ref
• Opening af text file in VBA
• How Can I Register The Yahoo DomainKey F
• Reading From excel spreadsheet cell
• Read data from excel through VB.NET
• Export four columns of a Spreadsheet to
• Need to Count the replacements made by a
• Symbols for VBA6.DLL?!
• Adding a worksheet to the workbook
• Excel Pivot Tables - Dynamically Changin
• Can no longer enter wscript for debug
• Filter string in GetOpenFilename method
• VBA Excel - Using FindNext function
• saving exel data
• Accessing Win32 API in VB script(.VBS fi

Hot Articles

• VBA eBook
• How to read a URL?
• office2003 chart object(Spreadsheet1, Ch
• Auto fit user form
• Access Developer Extensions
• Emails via Excel
• Excel: Copying cells under a specific ce
• Someone mind helping me with Error 426
• Order By DateDiff() in Access Report
• Disabling enter and mouse click PPT navi
• Wanting generate a HTML output right to
• Automating Microsoft MapPoint.
• How to refer to an object by the tab index
• Documentation on use of Me
• Path of MDB

Recommend Articles

• Close Access Form After Video playing
• VBA Excel Macro to delete rows based on
• How can I run sql command with no cofirm
• VBA Form in MS Word template to populate
• Accessing OLE object properties (powerpo
• Code erroring out.
• Using VBA to send an MSN instant message
• ScreenUpdating
• Overflow problem
• Filter string in GetOpenFilename method
• [Access SQL]: Have a function similar Or
• Help! Math problem
• Selecting Data By....
• Return value from running a sql statement
• List Box Selection via Code (Access 2003)