Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rating: Thread Rating: 3 votes, 5.00 average. Display Modes
Old 10-31-2013, 05:55 AM   #1
leo.clifton
Newly Registered User
 
Join Date: Jul 2013
Posts: 10
Thanks: 1
Thanked 0 Times in 0 Posts
leo.clifton is on a distinguished road
Document could not be registered / Could not open Macro storage

Hello

I have a VBA program which is stored in an Access database. The program creates letters using Word template documents as well as new Excel sheets. When one of the users in my team undertakes this process she is unable to create the files (although she could before). The following error message occurs initially for the word documents:

"The document could not be registered word 2010. It will not be possible to create links from other documents to the document"

When I enter debug and attempt to run the code again the file opens but subroutine halts again and I get a different message:

"Could not open Macro storage"

The line of code which is identified for both errors is:

Code:
Set wdDoc = wdApp.Documents.Open(TemplateLocation)
Where wdDoc is the a Word.Document, wdApp is a Word.Application and TemplateLocation is the path for the template

I have already checked the following:

- 'Trust access to the VBA project object model' in the Trust centre is ticked and Macro Security is set to none.
- DCOM Server Process Launcher is set to automatic in Services (Local)

Would appreciate any input here?

leo.clifton is offline   Reply With Quote
Old 11-04-2013, 04:38 AM   #2
leo.clifton
Newly Registered User
 
Join Date: Jul 2013
Posts: 10
Thanks: 1
Thanked 0 Times in 0 Posts
leo.clifton is on a distinguished road
Re: Document could not be registered / Could not open Macro storage

This problem has been recurring for a long time but this morning when we tried to replicate the symptoms for the benefit of our IM&T department it did not occur (typically). I cannot explain what the change is as I haven't adjusted anything other than the two solutions mentioned above which yielded no results originally. I have a feeling it may be to do with changing the Macro settings as detailed above and the user then logging out and back in after the weekend so this may be worth attempting for those experiencing similar problems.
leo.clifton is offline   Reply With Quote
Reply

Tags
excel , macro , vba , word

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to open a mailmerged Document DanielSpain Macros 1 01-03-2013 10:33 AM
macro to create hypalink in wod document smiler44 Visual Basic 0 07-07-2011 10:28 AM
Question Document Storage and indexing Stevieb General 2 01-27-2010 01:41 AM
Deleting a Macro when document is saved as scott-atkinson Visual Basic 1 02-22-2008 07:37 AM
Personnel / Document Storage, Archive GUIDO22 General 6 08-10-2007 03:28 AM




All times are GMT -8. The time now is 04:07 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World