Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Aug 2013
    Posts
    19
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Word VBA: how to check, maintain compatibility with different Office versions

    The VBA code I am writing now should work on Office 2007 & Office 2010.
    It is developed on office 2010.
    older versions are not expected to be required.

    Is there a way to check the VBA code (except for the dynamic run)?
    perhaps a script that can recognize unsupported constructs?

  2. #2
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    162
    Thanks
    0
    Thanked 24 Times in 24 Posts
    I have been developing VBA for Office Apps since the first Windows version. I have found it best to develop in the lowest version you want to support.

    There is a built in Compatability checker.

    Check file compatibility with earlier versions

    Check compatibility between your Microsoft Office files to see if features that are supported.

    Click the File tab.

    Click Info, and then click Check for Issues.
    Select Check Compatibility. Any issues between the versions are listed in the Summary.

    Note Selecting the Check compatibility when saving documents check box automatically checks for compatibility issues when you save your file as an earlier version.

    To save your file in an earlier format, see Save an Office file as an earlier version.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  3. The Following User Says Thank You to HiTechCoach For This Useful Post:

    YigalB (2013-08-13)

  4. #3
    New Lounger
    Join Date
    Aug 2013
    Posts
    19
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank you.
    I followed and I got empty list, so it looks like no compatibility issues, but it fail when I ran on office 2007.
    Could it be the check is not done on the VB code?

  5. #4
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    162
    Thanks
    0
    Thanked 24 Times in 24 Posts
    You will also need to be sure the document is in a trusted location for 2007.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  6. #5
    New Lounger
    Join Date
    Aug 2013
    Posts
    19
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by HiTechCoach View Post
    You will also need to be sure the document is in a trusted location for 2007.
    Could you explain this statement?
    Is there a "trusted location" definition?

  7. #6
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Location
    Oklahoma City, OK
    Posts
    162
    Thanks
    0
    Thanked 24 Times in 24 Posts
    Trusted Locations/documents is part of the new VBA security model stating with Office 2007.


    See:
    2007 http://technet.microsoft.com/en-us/l...ice.12%29.aspx
    2010 http://technet.microsoft.com/en-us/l...ice.14%29.aspx
    2013 http://technet.microsoft.com/en-us/l.../cc179039.aspx
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

  8. The Following User Says Thank You to HiTechCoach For This Useful Post:

    YigalB (2013-08-13)

Tags for this Thread

Posting Permissions

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