VBA reference via code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is it possible to add a VBA reference via VBA code.
For example I will need to check when the spreadsheet open if ADO reference
is setup, and if not set up to set it up.
Thanks.
Mark
 
Mark,

Try something like

On Error Resume Next
ThisWorkbook.VBProject.References.AddFromGuid _
GUID:="{B691E011-1797-432E-907A-4D8C69339129}", major:=0, minor:=0

See also www.cpearson.com/excel/vbe.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem adding a reference 4
VBA References 1
VBA code won't run, even with Macro Security set to Enable All Macors 9
VBA - ThisWorkbook 4
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Add Microsoft ActiveX Data Objects 2.8 Library in code 10
XCL 2010 VBA: I want to copy/paste from a rtf file to a spreadsheet 7
Remove a missing reference that is in use? 3

Back
Top