How to open Excel from Access 2013? RRS feed

  • Question

  • Recently updated to MS Access 2013 and now

    Dim objXLApp As Excel.Application

    causes Compile Error:  User defined type not defined.

    What is the 2013 way to do this?

    Thursday, July 10, 2014 6:08 PM


  • Hi ALMWO,

    You need to add reference to Microsoft Excel Object Library, in the VBA editor, goto Toos>References>Check Microsoft Excel 15.0 Object Library

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, July 11, 2014 7:38 AM