Error 5981 Office 2010
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business word cannot open the existing file normal dotm 2010 Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation could not open macro storage word 2010 Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like could not open macro storage 5981 you, helping each other. Join them; it only takes a minute: Sign up runtime error 5981 on Office/excel 2010 fresh installation up vote 1 down vote favorite I've created macro in excel 2013 where I point some
Word Cannot Open The Existing File Normal.dotm 2013
data from excel to Word (via word template). in excel 2013 everything works perfectly, but now I have to run this excel also in older company PC where is installed only M$ Office 2010/win7 - fresh installation. Set objDoc = objWord.Documents.Add(Template:=ThisWorkbook.Sheets("Data").Range("O1").Value & ThisWorkbook.Sheets("Data").Range("G2").Value) in this excel 2010 I get run-time error 5981 (application-defined or object-defined error). in cell "O1" is file folder where are this excel + word templates saved cell "G2" contain info which template could not open macro storage word 2013 should be used (according to dropdown selection). update: I've checked this on other PC with office 2010 and it works. Probably some add-in/library is not working correctly, but idk how to check it. excel share|improve this question asked Jul 21 '15 at 10:31 tryzhas 61 ok so I find out, you have to allow changes in word template. if you save template from other source, then you just need to open it, allow changes (in yellow row) and close...and it should work. –tryzhas Jul 21 '15 at 13:25 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote Error 5981 seems to have two descriptions attached to it (why?): Could not open macro storage Application-defined or object-defined error Since I got the second description I can only comment on that one, although "Could not open macro storage" seems to suggest that there is something wrong with (the macro's in) the Word file itself. In my situation the cause of error 5981 was that the Word-template was not a trusted document. When opening the Word-template manually, it was opened in protected view. When opening the template automatically via VBA this apparently results in an error 5981. share|improve this answer edited Oct 4 at 15:37 answered Sep 16 at 12:01 Emiel 464 add a comment| Your Answer draft
run a template which includes macros: Run-time word cannot open the existing file (normal) 2016 error '5981' (0x800A175D): Could not open macro storage
Word Cannot Open The Existing Global Template Mac
Cause The macros refer to another template which is not associated with
Word Cannot Open The Existing File Normal Dotm 2016
the template you are trying to open. e.g.: you built a template with some macros for entity "salesorder" but the template http://stackoverflow.com/questions/31536597/runtime-error-5981-on-office-excel-2010-fresh-installation refers to the quote.dot file. Solution To deal with this problem you'd have to built the template from scratch and pay attention to the references in the VB-project of the template.You can copy contents from another template but do not open http://support.mscrm-addons.com/instantkb/article.aspx?id=10125 another template and save it as a new one as in this case the reference to the old template will be set by default by MS Word. Related Articles No Related Articles Available. Article Attachments No Attachments Available. Related External Links No Related Links Available. Help us improve this article... What did you think of this article? poor 1 2 3 4 5 6 7 8 9 10 excellent Tell us why you rated the content this way. (optional) Approved Comments... No user comments available for this article. Created on 27.10.2006. Last Modified on 27.10.2006. Last Modified by MSCRM-Addons ->Team. Article has been viewed 13473 times. Rated 4 out of 10 based on 25 votes. Print Article Email Article
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login https://www.experts-exchange.com/questions/20385621/error-5981-could-not-open-macro-storage.html Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > error 5981 : could not open macro storage Want to Advertise Here? Solved error 5981 : could not open macro http://appsforoffice.freshdesk.com/support/discussions/topics/32728 storage Posted on 2002-10-29 MS Office 1 Verified Solution 8 Comments 1,608 Views Last Modified: 2011-04-14 hello everyone.. pls help!!! i am getting the above error INTERMITTENTLY when i run the 2 macros that i have created.. i know not open there is a similar article on this posted long back but that doesn't seem to resolve my problem... i have also gone thru the below link but all the options suggested don't seem to apply in my case - http://support.microsoft.com/support/kb/articles/q162/0/53.asp let me explain why... the 1st macro converts a doc file to pdf (by creating a postscript file first using a print driver and then creating the pdf from the .ps file using acrodist.exe).. the 2nd macro simply converts word cannot open the doc file to .prn using a print driver... both macros are executed via toolbar icons and are in the same template file (.dot) which is placed in C:\mydocs... also the workgroup template (Word -> Tools -> Options -> File Locations) is pointed to C:\mydocs so that the macros come up automatically when the doc is fetched from the repository (all docs are stored on a server)... also the output files (.pdf and .prn) go to a diff server. now the macros run fine but give the above error occasionally.. the options mentioned in the above link are not helping me since - - when the doc on which the macro error occurs is closed and again re-fetched from the repository, the macro runs fine... also the error does not occur always.. nor on any specific doc.. so normal.dot and vbe.dll should be supposedly fine (or else the error would happen for all) - n/w permissions are all correct for the same reason above - RAM is 255MB and HDD space is 20GB.. no other applications are open. pls let me know if i have missed anything or got something wrong.. pls advise. thanks in advance. aakash. 0 Question by:guptaak_2000 Facebook Twitter LinkedIn Google LVL 44 Best Solution bybruintje what also could be the case is that word leaves some intermediary files in the temp dir, and has trouble to get what it
1 5981-"Could not open macro storage" [RESOLVED ] adhoc error experienced when opening document from email S Suzy Davis started a topic about 3 years ago When I open a word document directly from an email, it opens three documents (2 blank), and presents the following error;This client is running apps FREE - I can't seem to reproduce this error. I've tried opening a couple of documents - one based on an APPS FOR OFFICE template and one not. Niether produced the error on a PC running both apps FREE and apps Efficiency.(Suggested trying with an document based on an APPS FOR OFFICE template because, if the document was originally built on the current PC experiencing the error it would reattach the template which has an AutoNew macro - not an AutoOpen which could conceivably have something to do with this error - but just though it would be useful to check.)Suggest trying the following:1. Does the error happen everytime you are opening a Word document from email?a. If no, which documents does it happen with - what is different about them? Do they have a macro call (select Alt+11 to check macros) Does the same document cause the error when not opened from email (ie save the document to your desktop and open it from the desktop.) Next try starting MS Word from the Start menu (or task bar), and opening the document via File > Open (2010/2013), or Word Start> Open (2007)b. Is it the time of day you are running it?2. Check Task Manager, with MS Word closed (preferably close using File>Exit (2010) or Word Start > Exit (2007), sort in Process order. If you see Winword.exe in the list, click on it, and select End process. Similarly, if Excel is closed and Excel.exe is in the list, close this process also. Sometimes MS Office doesn't close applications off properly - especially if a document or workbook crash has occurred on the PC.3. Is a Windows update, Backup, or other process that might be using resources running?4. Always a good idea to clean up any tmp files - With all applications closed, search *.tmp and delete them, then search ~*.* and delete them. Those you can't delete, are required. 1 Comment S Suzy Davis said about 3 years ago This error is caused by Protected View being set in MS Word which protects you from opening a document from Outlook or the Internet which intiates code on your PC - even though it's an addin you've got i