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

    VBA 6.5 to VBA 7.0

    Hello
    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. #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
    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
  •