Computer Performance Lag from XL2CAD

[Anonymous]

Ever since installing XL2CAD 3.0 I've been having computer performance problems. Here is what happens: whenever AutoCAD (2005) is running, the computer performance spikes to 100% - I monitor this on the Task Manager. However, when a command is active, for example when I am drawing a line or searching through the toolbar pull down menus, then the performance drops off to regular levels.
This only happens when a drawing file is open and this process repeats until I close ACAD. This happens when I am only running ACAD and when the program is operating in the background.
My company has a network license for the XL2CAD product, and my computer is the first computer that we have been having problems with. The only solution I've found is to remove the program - this solves the performance issue immediately. But, I need to use the program because everyone else at the company is using it.

Thank you.
Erik

[Anonymous]

Wellcome to the club. We have other reasons for not wanting XL2CAD present. (It halts applications that have forms open for example.) We use the following to unload it automatically.


Private Sub TestUnlXl2CAD()
UnLApp ("xl2cad")
End Sub

Function UnLApp(ByVal aPP As String)
Dim objVB As VBE
Dim item
Dim objComponents
Dim value As String
Set objVB = ThisDrawing.Application.VBE
Set objComponents = objVB.VBProjects
For Each item In objComponents
value = getTail(getHead(item.FileName, "."), "\")
On Error Resume Next
If UCase(value) = UCase(aPP) Then
UnloadDVB item.FileName
Exit For
On Error GoTo 0
End If
Next
Set objComponents = Nothing
Set objVB = Nothing
End Function

Function getHead(ByVal pathStr As String, ByVal deLim As String) As String
Dim x As Integer
Dim H As String
x = InStrRev(pathStr, deLim)
On Error Resume Next
If x > 0 Then
H = Left(pathStr, x - 1)
End If
getHead = H
On Error GoTo 0
End Function

Function getTail(ByVal pathStr As String, ByVal deLim As String) As String
Dim x As Integer
Dim T As String
x = InStrRev(pathStr, deLim)
If x > 0 Then
T = Right(pathStr, Len(pathStr) - x)
End If
getTail = T
End Function

[Anonymous]

AKS-
Forgive the ignorance of these questions, but where exactly do I post this code to unload XL2CAD? Also, what happens to XL2CAD when I unload it - I assume I can still use it when exporting to ACAD, right?

Thanks much.
Erik

[arcticad]

Private Sub AcadDocument_activate()
Call UnLApp("xl2cad")
End Sub

Hey AKS, thanks for integrating the code.

It was discussed over here also.

http://discussion.autodesk.com/thread.jspa?messageID=5489635

[Anonymous]

>> The only solution I've found is to remove
>> the program.

That's probably the best thing to do.

Consider vetting your procurement process and,
and make sure that the vendor has professional
software engineering credentials and qualifications.

From the description of your problem, whomever
sold you that garbage, probably shouldn't be in
the software business. Often, this type of problem
is a result of an inexperienced programmer resorting
to kludges that would not be required by someone
with experience in using the right tools for the job.


--
http://www.caddzone.com

AcadXTabs: MDI Document Tabs for AutoCAD 2004/2005/2006/2007
http://www.acadxtabs.com

wrote in message news:5495977@discussion.autodesk.com...
Ever since installing XL2CAD 3.0 I've been having computer performance problems. Here is what happens: whenever AutoCAD (2005) is running, the computer performance spikes to 100% - I monitor this on the Task Manager. However, when a command is active, for example when I am drawing a line or searching through the toolbar pull down menus, then the performance drops off to regular levels.
This only happens when a drawing file is open and this process repeats until I close ACAD. This happens when I am only running ACAD and when the program is operating in the background.
My company has a network license for the XL2CAD product, and my computer is the first computer that we have been having problems with. The only solution I've found is to remove the program - this solves the performance issue immediately. But, I need to use the program because everyone else at the company is using it.

Thank you.
Erik

[Anonymous]

There are a number of things to mention:
- The latest version of XL2CAD may be 4. The problems you have may not exist in version 4.

- The unlapp code posted here requires a reference to a Microsoft extensibility library in order for it to work. That was not mentioned. Follow the link by arcticad to the post where he mentions it. arcticad posted this method (thanks again btw). Incidentally this method seems like a long way to accomplish what looks like what can be done in one line. It may, thought not intended for the purpose here, be the only way to discover the true path name needed for unloading purposes, particularly the active VBA. Unfortunately, Application.VBA.AciveVBproject.FileName does not always return the active running VBA!

- Start a new AutoCAD drawing file. Type in VBAMAN and check if XL2CAD is loaded. Make a note of its path. Then select it and unload it. Close out VBAMAN and type VBAMAN again to verify XL2CAD is unloaded. Start another new AutoCAD drawing file. Type VBAMAN again to check if XL2CAD is loaded. It probably will be loaded because one of the AutoCAD lsp files that is run when any file is loaded has a line to load XL2CAD once XL2CAD is installed. For my setup I am not permitted to change that file, so this unloading VBA procedure is used as a backdoor method to unload XL2CAD whenever necessary. This procedure has been added to all VBA applications that open new files and that keep a userform open on the screen during the process. A batch process that uses the userform to track the process is one example. Having XL2CAD present during those conditions produces an error.

- Having XL2CAD present at all times is not necessary, so it seems to me. The XL2CAD toolbar loads it when it needs it. Perhaps it is supposed to be present for automatic updating to occur, however, that functionality does not seem to work and from my own experiments is something you would not want to happen automatically. Maybe it does for you. A big problem with automatic updating is the linked table, an AutoCAD block, turns to dust without any warning when the named range XL2CAD puts in the Excel spreadsheet does not exist!

- Keeping in mind that I have to resort to backdoor methods and realizing that XL2CAD was sitting locally on my machine, I moved it to a sub folder I added where it was originally loaded. AutoCAD cannot find it, so I'm set.

- There are many different ways for you to run this macro. You can search through the postings for running a macro. Whatever you use is probably going to be temporary because the true solution as Tony mentioned will be to keep it from loading in the first place.

[Anonymous]

Tony,

While I appreciate your willingness to contribute, the ridicule is unprofessional and the slander is unnecessary.

For the record, our company has used XL2CAD for a long time and we are pleased with the program overall. We've been noticing technical problems on 1 workstation and good operation on between 30 to 50 machines, hence the post.

Respectfully,
Erik