Link to home
Start Free TrialLog in
Avatar of Mitchell_
Mitchell_

asked on

Unable to Open Macro Storage on Export from Access to Word

Guys:

Before you say anything, I did see "that MS KB article" that everyone talks about when this question is posted, but it didn't help. I am running on Windows XP, with local admin rights, and the code works fine. A user then comes and log into my machine (losing local admin) and they get the Unable to open macro storage error, failing on:

Set WordDoc = WordApp.Documents.Open(FileName:="C:\FSBDB\q3-blank.doc")

Is there any way around this? The document is a word form (form fields) that I am dumping data into from the database table.. It works SO beautifully when I do it and it'd just kill me if I couldn't use it because of permissions.

Here's the complete code:
If WordApp Is Nothing Then
    Set WordApp = New Word.Application
Else
    Set WordApp = GetObject(, "Word.Application")
End If

If err.Number <> 0 Then
    err.Clear
End If

On Error GoTo 0

WordApp.Visible = False

Do While Not rs.EOF

Set WordDoc = WordApp.Documents.Open(FileName:="C:\FSBDB\q3-blank.doc")

    Bookmarks("txtTitle").Range.Fields(1).Result.Text = rs!Title
       
    .FormFields("lstDivision").Result = rs!Division
    .FormFields("lstCoreBusiness").Result = rs!CoreBusines
    .FormFields("lstProgram").Result = rs!SubItem
    .FormFields("lstThroneSpeech").Result = rs!ThroneSpeech
    .FormFields("lstBudget").Result = rs!Budget
    .FormFields("lstKeyStrategies").Result = rs!KeyStrategy

etc.....
Avatar of jadedata
jadedata
Flag of United States of America image

Hey Mitchell_!

  This sounds more like a Word error being passed thru to Access.

  See this link:  http://www.support.softwaretechnology.biz/main/R10650.htm about mid page regarding your dilemma.
  See also: http://dbforums.com/arch/219/2003/1/666622  this refers to the MSKB thing but there's more.

regards
Jack
Avatar of Mitchell_
Mitchell_

ASKER

Thanks but..

I don't see how it could be a word error when the export works fine under my administrative account.. It's just when a 'regular user' tries it that it fails.. wouldn't that mean permissions?

any other thoughts?
Access permissions don't mean anything to a Word Document.

There is some |other| difference in operations when your other user is logging on.
If you want to completely rule out a permissions issue, put that user in the Admins group (or your SuperGroup) and try the op again.
I woud say that it could be a rights issue. Check where the temp directory points to when the user logs in and make sure the user can create files in this directory.
Jack Mitchell means Operatings System permissions, not access permissions.
oh,...ok
Which version of MS-Office.
(Office97 has specific permissions issueswhen run on Win2000 or later).

Pete
it's office 97 - you know of something offhand with O97 and macros?
Office 97 macros do not run on Win2000 and later for non-privileged users without registry changes.
I'll try to find the KB article.

Pete
Pete:

Thank you for the article. That's definetly been confirmed as the problem.

Now, My problem is that I do not have admin access on any machine other than my own to apply this fix, and the IT folks definetly won't want to update 100+ machines to accomdate my little application.

Is there another way to get this data out to word via access into these form fields?

ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Pete:

Thank you. I'll do that.