?
Solved

how to speed up vba 64 bit version

Posted on 2016-08-10
2
Medium Priority
?
83 Views
Last Modified: 2016-08-30
vba 32 bit runs fast but running same routine on 64 bit is extremely slow.  can I install vba enabler 32 bit on 64 bit application?
0
Comment
Question by:Cad Coder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 56

Accepted Solution

by:
Bill Prew earned 2000 total points (awarded by participants)
ID: 41751975
I noticed this question had gone unanswered for a bit so wanted to offer a little help.  But I have to say I am not a current AutoCAD user (used it a number of years ago), and don't have personal experience with your problem.  However as an expert interested in Windows and scripting in general I did a little research.

It sounds like when AutoCAD was ported to a 64 bit version that the way they had to approach VBA caused some major performance issues.  You already know that.  Looking on some of the Autodesk support sites it seems like you have a few choices.

(1) Uninstall AutoCAD 64 bit and install AutoCAD 32 bit.  This seems to reslove the VBA performance issue, but naturally other AutoCAD functions will be slower.

(2) Convert your VBA routines to VB.NET.  Performance will be great there, but there is a learning curve to get to VB.NET, and it is more complicated.

(3) Convert your VBA routines to Visual LISP.

Sorry there isn't a simple solutions, you may want to post on some of the AutoCAD specific support forums and see if you can get additional information and help there.  A few links below that might be helpful.

http://forums.autodesk.com/t5/autocad-civil-3d-general/vba-conversion/td-p/4523705
http://blog.jtbworld.com/2013/09/autocad-performance-issues-and-vba.html
http://www.cadtutor.net/forum/showthread.php?65966-VBA-on-AutoCAD-2012-64-bit

~bp
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Modern/Metro styled message box and input box that directly can replace MsgBox() and InputBox()in Microsoft Access 2013 and later. Also included is a preconfigured error box to be used in error handling.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses
Course of the Month11 days, 10 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question