Solved

how to speed up vba 64 bit version

Posted on 2016-08-10
2
69 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 55

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

707 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