Solved

how to speed up vba 64 bit version

Posted on 2016-08-10
2
51 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
2 Comments
 
LVL 54

Accepted Solution

by:
Bill Prew earned 500 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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
modifying VBScript to VBA 17 74
VBA Script to return Folder File and Folder count 8 31
Excel vba question 7 45
Turning off query prompts on runtime version of Access 2016 5 18
This is an Add-On procedure to be used in conjunction with the code provided in Reducing EE Email Clutter using Outlook (http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3146-Outlook-Processing-EE-emails-on-Receive.…
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
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…

726 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