Results 1 to 5 of 5
  1. #1
    Lounger
    Join Date
    Apr 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs up

    I want to use a single add-in in both Word 2003 and 2007 (so that I only have to maintain one). The add-in has VBA code which does a number of things including customising the UI. I have code to create a custom toolbar etc that I develoepd in W2003. I also have RibbonUI customisations working fine in W2007.

    Microsoft advice is that this is possible. They advise on using the Application.Version property to fork the VB code according to the platform that opens the file (see http://msdn.microsoft.com/en-au/library/aa722523.aspx). This makes sense.

    So, I've done all the coding in W2007. I have installed the Compatibility Pack so that W2003 can open the W2007 files. I open the docm file in W2003 and find ... nothing. All the VB modules are just not there. I open the file in W2007, and there they are. But not in W2003.

    Does anyone know what could be causing W2003 not to see the VB modules created in a W2007 docm file ? Have I missed something ? Is the problem with the Compatibility Pack ?

    Many thanks.
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  2. #2
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    While there are some file types that the Compatibility Pack doesn't recognize (such as .dotx templates), I thought .docm files should be OK.

    I just opened a test macro-containing .docm file on two PCs, one with Word 2002, and one with Word 2003.

    In Word 2002, the file opens, I get a macro warning, and the module and macro are visible and functional.

    In Word 2003, no macro warning, and no module - interesting!

    Not sure why this is....

  3. #3
    Super Moderator
    Join Date
    Dec 2000
    Location
    New York, NY
    Posts
    2,970
    Thanks
    3
    Thanked 29 Times in 27 Posts
    [quote name='GarryBrooke' post='780219' date='16-Jun-2009 22:25']Does anyone know what could be causing W2003 not to see the VB modules created in a W2007 docm file ? Have I missed something ? Is the problem with the Compatibility Pack ?[/quote]
    Check to see what Service Pack version your Word 2003 installation is up to.

    When I did the previous test, it was on a PC that for whatever reason still had Word 2003 SP1. I've just updated that to Service Pack 3, and now the .docm file does open with the macro available.

    Gary

  4. #4
    Lounger
    Join Date
    Apr 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='Gary Frieder' post='780229' date='17-Jun-2009 13:44']Check to see what Service Pack version your Word 2003 installation is up to.[/quote]

    Gary thanks. Yes, we are missing the SP1 update and the two security updates to the Compatibliity Pack. Our IT people say it will take more than 3 months to put through their change control process and by then we will have switched from Office 2003 to 2007.

    They were surprised when I mentioned that no-one can open Excel 2007 files in Excel 2003. I think that is another symptom of not having all the service packs installed.

    Cheers.

    Garry
    <img src=/S/flags/Australia.gif border=0 alt=Australia width=30 height=18>

  5. #5
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    [quote name='GarryBrooke' post='780391' date='17-Jun-2009 15:21']Our IT people say it will take more than 3 months to put through their change control process and by then we will have switched from Office 2003 to 2007.[/quote]
    Maybe they will find a way to speed it up if they are frequently required to convert documents for Office 2003 users...

Posting Permissions

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