#1
|
|||
|
|||
Change library reference location
A user in our office has 64-bit Office. A VBA project will not compile because of a missing DAO 3.6 reference. The dao360.dll file is in C:\Program Files (x86)\Common Files\microsoft shared\DAO. However, the VBA reference (used in an Add-in) is to the same location, except Program Files rather than Program Files (x86). I have tried registering the file with regsvr32 (I don't know if there is a different option for 64 bit). While the registration is reported as successful, the reference in the VBA editor (Tools > References) remains at Program Files instead of Program Files (x86). I am sure there is something about this registration process I do not understand, but everything I have been able to find other than VBA solutions seems to indicate something along the lines of what I have already tried without success. Edit: To provide a little more information, the DAO 3.6 reference is because a user form is getting the row source for a combo box from an Access file. Last edited by BruceM; 12-09-2015 at 05:31 AM. Reason: Further information |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft Excel 12.0 Object Library reference upload | chamdan | Project | 2 | 04-21-2014 06:30 AM |
Change default location for save does not work | sportflyer | Word | 4 | 02-06-2014 04:43 PM |
Can't change inbox data file location | Stephen Waugh | Outlook | 0 | 01-10-2013 01:13 PM |
How to change save location and file to print name change? | albertc | Excel Programming | 1 | 05-13-2012 07:05 PM |
Excel VBA: How to add a reference to Microsoft Word Object Library? | tinfanide | Excel Programming | 7 | 12-12-2011 05:21 AM |