An Error Occurred Initialising The Vba Libraries 40040
Contents |
Forum Microsoft Office Application Help - Excel Help forum Excel General Excel 2007 : Macros disappear after saving file, closing it and opening
An Error Occurred Initializing The Vba Libraries 40040
again? To get replies by our experts at nominal charges, follow an error occurred initializing the vba libraries (1004) this link to buy points and post your thread in our Commercial Services forum! Here is
An Error Occurred Initializing The Vba Libraries (14) Excel 2013
the FAQ for this forum. + Reply to Thread Results 1 to 3 of 3 Excel 2007 : Macros disappear after saving file, closing it and opening again? an error occurred initializing the vba libraries 40040 excel 2007 Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating Excellent Good Average Bad Terrible Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-04-2012,07:55 AM #1 uzman1243 View Profile View Forum Posts Registered User Join Date 03-02-2012 Location Sri Lanka MS-Off Ver Excel 2003 an error occurred initializing the vba libraries 1004 excel 2013 Posts 10 Macros disappear after saving file, closing it and opening again? Hi I created A workbook with a few macros. After I saved the workbook, close it and ope it all the macros have gone. when i click on a button (assigned to a macro) it says "cannot run the macro "workbook.xlsx'!Nextinvoice'. The macro may not be available in this workbook or all macros are disable." after that another error comes up saying "an error occurred while initializing the VBA libraries (40040)" I tried reinstalling ms office 2007 and still doesnt work can you please help? Register To Reply 03-04-2012,08:57 AM #2 mrice View Profile View Forum Posts Forum Expert Join Date 06-22-2004 Location Surrey, England MS-Off Ver Excel 2013 Posts 4,606 Re: Macros disappear after saving file, closing it and opening again? You need to save your workbook in macro-enabled format which has the suffix .xlsm Martin If my solution has saved you time and/or money, please consider donating to a family fu
from GoogleSign inHidden fieldsSearch for groups or messages
work simultaneously on excel file. But it is possible only one person can work .when accessing this file by others its http://external-hdd-raam.blogspot.com/2012/06/how-to-fix-initializing-vba-libraries.html showing the error "an error occurred initializing the vba libraries 40040".Please give the solution ASAP.. Reply With Quote #2 Old 11-01-2012 Gania Gania is offline Member Join Date: Nov 2010 Posts: 480 Re: How to fix initializing the vba libraries 40040 error in Microsoft Excel There are around 3 possibilities that you can try out. First check the Excel macros names an error assigned to cells in a spreadsheet macros. You need to only need to open the book and stop the use macros for start being. If you had given permission to use macros to a workbook. Second the execution of macros that run are equals vba macros. Select the macro to run and from the dialog that appears by pressing F8 or click an error occurred on Menu > Tools > Macro. Reply With Quote #3 Old 11-01-2012 Alfons Alfons is offline Member Join Date: Nov 2010 Posts: 410 Re: How to fix initializing the vba libraries 40040 error in Microsoft Excel VBA recognizes objects that are declared dynamically or static, sometimes if they are incorporated as shown in code, or we forget, or you do not realize their presence days or until the conflict is at stake for the lack or nuisance to a secondary object, or even a different version. By default, I believe there are four basic references. For add-ins, I do not remember, but the same applies for self-installation, I get even do it in VBS. Reply With Quote If you like this post then consider sharing it with others. Posted by raam at 14:27 0 comments: Post a Comment Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) There was an error in this gadget Read - Share - Comment Results (New) Home Subscribe Newsletter Search this Site Facebook Fans Search this Site Subscribe - Follow Facebook Recommendations Live Cric