Thread: VBA 6.5 to VBA 7.0
2014-03-10, 03:09 #1
- 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..
Subscribe to our Windows Secrets Newsletter - It's Free!
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!
+ 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!
2014-03-13, 12:34 #2
- 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."