No Microsoft Office XX.0 Object Library in Access 2016 (1 Viewer)

SBBmaster09 · Aug 18, 2017

Hi,

I am currently developing in Access 2016. My Microsoft is Office 365. I need to input FileDialog to be able to upload an excel file to a table.

Mostly it says add that Microsoft Office xx.0 Object library. But I can't find it in Access 2016 References. I tried to check in Excel Reference but it is there.

What is the possible thing in order to find that thing or able to also check it in Access 2016.

Thanks.

static · Aug 18, 2017

Check C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICEXX\MSO.DLL

In Access you can query references with this, (not sure if it'll work in Excel)...

Code:

Dim r As Reference
For Each r In References
    Debug.Print r.Name, r.FullPath
Next

I'm on 2010...

VBA C:\PROGRA~2\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL
Access C:\Program Files (x86)\Microsoft Office\Office14\MSACC.OLB
stdole C:\Windows\SysWOW64\stdole2.tlb
DAO C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL
Office C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\MSO.DLL

edit:

You only need the reference for the constants which you don't really need

saveas= 2
open=1
folderpicker=4
filepicker=3

No Microsoft Office XX.0 Object Library in Access 2016 (1 Viewer)

SBBmaster09

Registered User.

static

Registered User.

Similar threads

Users who are viewing this thread