Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2014
    Thanked 0 Times in 0 Posts

    VBA 6.5 to VBA 7.0

    We have a small VBA app at work that are witten in VBA 6.5
    The program rather small and simple ( i did not write it and are a complet newbe here) and gather information for various sharepoint lists and makes different pdf files . (simply put)

    after my company upgraded form excel 2007 to excel 2010 (vba 7.0) excel is shutting down when trying to use the vba
    "excel has stopped working"
    choises: restart or debug

    Debug tries to use Visual studio 2010.. and that want work.

    so im in the dark

    would be very happy if any had any suggestions..

  2. Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    2 Star Lounger HiTechCoach's Avatar
    Join Date
    Sep 2011
    Oklahoma City, OK
    Thanked 24 Times in 24 Posts
    Sounds like you have installed the 64-bit version if Office 2010. The code for Office 2007 is 32-bit.

    The simple and recommend solution is to uninstall Office 64-bit version and install the Office 32-bit version. Even Microsoft recommends using the 32-bit version.

    If you must use the 64-bit version then you will need to upgrade the code to 64-bit.
    Boyd Trimmell aka HiTechCoach (Access Information here)
    Microsoft MVP - Access Expert
    "If technology doesn't work for people, then it doesn't work."

Posting Permissions

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