Topic: Unloading all VBA projects..

[hardwired]

Hi,

In either lisp or vba, (posted this in both forums) is there a way of setting-up a command that unloads all vba projects, basically automating going through vbaman and unloading each project..

[Bryco]

I only have one big project and let it load the acad.dvb way and never unload it, is there an advantage to having lots of little ones?

[Keith™]

I only have one big project and let it load the acad.dvb way and never unload it, is there an advantage to having lots of little ones?

I find small individual projects easier to manage

[Bob Wahr]

In response to the one big vs. lot's o little, I prefer each routine or routine group to be it's own dvb for the same reason that each project gets its own folder.  I can dump everything into the same one but that makes it more tedious to dig for what I need.

Opinion on unloading, is there a reason?  I load what I need, when I need it.  It unloads when I close acad and I don't notice any performance knock when doing it.

Answer to the question, there is no way using VBA alone to unload all VBA projects.  You can unload most of them, but a project can't be unloaded if it's running so it can't unload itself.

non-sequitur, I like coffee a lot.  It smells good, it tastes good, it makes my life fulfilled.

[deegeecees]

As far as incorporating updates into your users Acad, here's how I used to do this:

All Lisp/VBA files reside in a directory for support files located on a network server and users AutCad support directory structure pointing to it. I would have my own profile for my testing, and the same one as the users. I'd switch between the two for testing. When things are working to my satisfaction, I'd send out an email to let the users know to shut down for 5 min while I transfer the files. If they didn't shut down Acad, then I'd usually get a call saying something locked up by the person who did not follow directions (didn't happen too much as they were a smart bunch).

And yes, each function had it's own file. This way some could be called without the overhead of a huge file.

[David Hall]

what about a lisp command that loads, runs, and unloads the vba file?

[rogue]

I also have a "loader" dvb routine, with a small footprint. Since some of my routines use events, it's also an easy way to stop event polling.

[fixo]

Hi,

In either lisp or vba, (posted this in both forums) is there a way of setting-up a command that unloads all vba projects, basically automating going through vbaman and unloading each project..

Not sure about that it's what you exactly need
This code will remove project from drawing
Just open VBAIDE, import this .bas file then run it:

Code: [Select]

' modCleanUp.bas ' <--Important! Save with this file name only
Option Explicit
' request reference to:
' Microsoft Visual Basic For Application Extensibility 5.3
Sub CleanUp()
Dim vbcom As VBComponent
On Error Resume Next
    For Each vbcom In ThisDrawing.Application.VBE.ActiveVBProject.VBComponents
        If vbcom.Name <> "modCleanUp" Then
            ThisDrawing.Application.VBE.ActiveVBProject.VBComponents.Remove vbcom
        End If
        Debug.Print vbcom.Name 'for the debug only
    Next vbcom
End Sub

[rkmcswain]

Another thread here with a possible solution.

http://www.cadtutor.net/forum/showthread.php?t=24053