+ Reply to Thread
Results 1 to 9 of 9

How to restore default VBA libraries in Excel 2013?

  1. #1
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    How to restore default VBA libraries in Excel 2013?

    Hello everyone,

    I'm a beginner with Excel VBA. I did a search on this forum and didn't see anything related, but I'm wondering if there is a way to restore the default reference libraries that are checked the first time you open Tools => References in VBA in Excel 2013. I think I accidentally unclicked something that's necessary to run the program, and I can't find a "default restore" option or anything of that sort.

    Thanks in advance for your help.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How to restore default VBA libraries in Excel 2013?

    The references are workbook specific. What problem are you facing and which library do you think is missing?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: How to restore default VBA libraries in Excel 2013?

    Hello Rory,

    I am trying to write a function that exports a table from Excel and adds it to an existing database in Access. Previously, I received an error 3343, and tried to solve the problem by adding and removing various libraries. Now, I am getting an error message that says "Compile Error: Method or Data Member not Found", and it highlights the very first line of my subroutine [the line that reads "Sub ExportToAccess () ].

  4. #4
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How to restore default VBA libraries in Excel 2013?

    That is unlikely to be a reference issue, I would say. It would indicate you are trying to use a property or method that doesn't exist for the object in question. Can you post the routine?

  5. #5
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: How to restore default VBA libraries in Excel 2013?

    As for the libraries, I have no idea which one is missing--this is why I'm looking for the option to restore the defaults. But the libraries I currently have checked are as follows:

    Visual Basic for Applications
    Microsoft Excel 15.0 Object Library
    Microsoft DAO 3.6 Object Library
    Microsoft Forms 2.0 Object Library
    Microsoft Office 15.0 Object Library
    OLE Automation
    Microsoft Access 15.0 Object Library

  6. #6
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: How to restore default VBA libraries in Excel 2013?

    Sure, the routine I have is as follows:

    Please Login or Register  to view this content.

    I should note that I got this code from the following video on Youtube: http://www.youtube.com/watch?v=7o_jOWpi3Dc

    Regards,
    Jeremy
    Last edited by alansidman; 05-22-2014 at 11:46 AM.

  7. #7
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365 Win 11 Home 64 Bit
    Posts
    20,944

    Re: How to restore default VBA libraries in Excel 2013?

    Code Tags Added
    Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

    Posting code between
    Please Login or Register  to view this content.
    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan


    Have you debugged your code?
    Database Normalization
    What is Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  8. #8
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: How to restore default VBA libraries in Excel 2013?

    This:
    Please Login or Register  to view this content.
    should be this:
    Please Login or Register  to view this content.

  9. #9
    Registered User
    Join Date
    05-21-2014
    Posts
    5

    Re: How to restore default VBA libraries in Excel 2013?

    Thank you, that change overcame the Compile Error. I am still getting a 3343 Error when I try to run the program. However, I'm not sure if this is due to a missing reference library, or a flaw in the code, so I think it would be more appropriate as a separate topic.

    Thanks again for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Restore default settings?
    By JapanDave in forum Excel General
    Replies: 20
    Last Post: 07-14-2012, 02:32 PM
  2. Replies: 1
    Last Post: 12-20-2011, 05:31 PM
  3. How to restore default Shortcuts
    By ken90267000 in forum Excel General
    Replies: 2
    Last Post: 11-19-2008, 10:28 PM
  4. Replies: 1
    Last Post: 02-13-2005, 10:08 PM
  5. [SOLVED] Restore default menus
    By Luis in forum Excel General
    Replies: 4
    Last Post: 01-09-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1