Consulting

Results 1 to 11 of 11

Thread: Word form template macros not working in SharePoint

  1. #1
    VBAX Regular
    Joined
    Aug 2004
    Location
    Seattle, Washington area
    Posts
    7
    Location

    Word form template macros not working in SharePoint

    I've created a Word 2002 form that has many macros to automate tasks when exiting a form field. The users need to access the form through SharePoint. After publishing on SharePoint, some users open the template and it works fine and other users don't have the macros at all.

    SharePoint is on a network server, and desktops were installed to point to C:\ for templates (and normal.dot) and the executables.

    How do I distribute the form with macros through SharePoint?

    Thanks in advance for help.

  2. #2
    VBAX Tutor jamescol's Avatar
    Joined
    May 2004
    Location
    Charlotte, NC
    Posts
    251
    Location
    I've seen this behavior a number of times. If you will, post the following information. Sharepoint contains many elements, any number of which can create this issue.

    1. Version of SP (including service pack)
    2. Version of IIS on the SP server
    3. OS version of the SP server w/SP Level
    4. Workstation OS with SP level
    5. Workstation IE version and SP
    6. Office SP level
    7. Is Sharepoint configured to use SSL?
    8. Are your users opening the Word doc via HTTP or opening it using the "Document | Edit in Word" menu from Sharepoint?

    I know this is a lot, but necessary to troubleshoot the problem.

    James
    "All that's necessary for evil to triumph is for good men to do nothing."

  3. #3
    VBAX Regular
    Joined
    Aug 2004
    Location
    Seattle, Washington area
    Posts
    7
    Location
    I'll forward the questions to our Sys Admin and get back to you next week with his reply. Thanks for confirming that you've seen this problem before.

    Lorrie

  4. #4
    VBAX Regular
    Joined
    Aug 2004
    Location
    Seattle, Washington area
    Posts
    7
    Location

    Arrow

    Okay, James, here's the answers about our configuration:


    1. SharePoint version is 2001, Service pack 2. Service pack 3 install is scheduled for 2 weeks out.
    2. Version 5 of IIS
    3. OS version is 2000 Server standard SP 4
    4. Workstation OS is Windows 2000 SP 4
    5. Workstation IE version 6.0 SP 1
    6. Office SP level is SP1
    7. SharePoint is not configured to use SSL
    8. Users are opening the Word doc via HTTP
    Last edited by lagordon; 08-26-2004 at 04:13 PM.

  5. #5
    VBAX Regular JOrzech's Avatar
    Joined
    Jun 2004
    Location
    Upstate New York
    Posts
    83
    Location
    What are the users' macro security levels set to? Are they all the same?
    Joanne

  6. #6
    VBAX Tutor jamescol's Avatar
    Joined
    May 2004
    Location
    Charlotte, NC
    Posts
    251
    Location
    Joanne hit the nail on the head. My research says HIGH macro security levels are the most likely culprit. Check the security level (Tools | Macros | Security) for each individual Office application. It must be Medium or lower (though lower levels are not safe) for your macro/form to work.

    James
    "All that's necessary for evil to triumph is for good men to do nothing."

  7. #7
    VBAX Regular
    Joined
    Aug 2004
    Location
    Seattle, Washington area
    Posts
    7
    Location

    Unhappy

    All users were set to medium before this started. They get the error message and then respond to enable the macros. Sorry, but that's not the issue.

    Lorrie

  8. #8
    VBAX Regular JOrzech's Avatar
    Joined
    Jun 2004
    Location
    Upstate New York
    Posts
    83
    Location
    Just for clarification, all the macros are stored in the template itself. Correct?
    Joanne

  9. #9
    VBAX Wizard
    Joined
    May 2004
    Posts
    6,713
    Location
    And check to se if the users have the reference made to the WinHTTP.DLL. it is crucial for using http protocol within Word.

  10. #10
    VBAX Regular
    Joined
    Aug 2004
    Location
    Seattle, Washington area
    Posts
    7
    Location
    The macros are stored in the template itself.

    Where would I check for the user reference to WinHTTP.DLL?

    BTW, I followed up on a reference to the Workgroup Templates folder on the MS support webpages. I setup a shared folder on the SharePoint server for templates, pointed the template file location for Workgroup Templates to that shared folder, and then tried again to publish the template to SharePoint. The good news is that is that the macros now work. The user opens the template through SharePoint, saves it as a document to their desktop, and the macros execute as planned. The remaining awkwardness is that it is opening as a template, so that user must go through changing it to Save As document. But at least the macros in the form work.

    Lorrie

  11. #11
    VBAX Regular JOrzech's Avatar
    Joined
    Jun 2004
    Location
    Upstate New York
    Posts
    83
    Location
    lagordon

    To check for reference to WinHTTP.dll, open your template, press Alt F11, View, Project Explorer, click on your project (template). Go to Tools, References, and see if there a check mark next to it. If there is and it's still not working, you may need to register the dll with regserv32.exe by copying the dll and pasting it into regserv32.exe. I'm actually not familiar with Win HTTP.dll, but am familiar with registering other components.

    I am so pleased you got most of it working....
    Joanne

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •