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.
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
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 () ].
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?
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
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.
Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code betweentags makes your code much easier to read and copy for testing, it also maintains VBA formatting.Please Login or Register to view this content.
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 עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
This:
should be this:Please Login or Register to view this content.
Please Login or Register to view this content.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks