VBA-subsystem

Discussion in 'AutoCAD' started by Jan van de Poel, May 17, 2004.

  1. Hi, is it possible to disable this VBA-subsystem in a drawing?
    Or, what does it do?

    We received a 171KB drawing from an architect, it takes ages to load and
    display (over an hour),
    used system: P4-1.8GHz, 256Mb mem., 128Mb Nvidea video, 20gig hard disk
    space.

    Jan
     
    Jan van de Poel, May 17, 2004
    #1
  2. Jan van de Poel

    thenrich Guest

    What does VBA have to do with your delay? 171kb doesn't seem that large ....
     
    thenrich, May 17, 2004
    #2
  3. Jan van de Poel

    Mark Propst Guest

    He must mean 171mb?

    .....
     
    Mark Propst, May 17, 2004
    #3
  4. Jan van de Poel

    Tim Arheit Guest

    VBA runs code that may be embedded in the drawing. Once you have it
    open have you checked what code is in the drawing? (using the vbarun
    command. You can remove the offending code using the editor.)?

    VBA itself only takes a second to load, so I'm assuming that either
    code is being run on startup or it's simply the last message you see
    before it takes forever.
    Unless you mean 171MB this machine shouldn't have a big problem with
    this file. You could try inserting (or xrefing) the drawing into a
    new one.

    On the other hand the file is 171MB then I'm not surprised it takes an
    hour to load. I wouldn't every try loading a 171MB file on a machine
    with less than 1GB of memory.

    -Tim
     
    Tim Arheit, May 17, 2004
    #4
  5. Jan van de Poel

    Mike Weaver Guest

    If the vba you're having trouble with is embeded you can use the extract
    button in vbaman. Otherwise you will have to remove all suspect vba
    projects from your startup suite as well as hiding any acad.dvb in your
    search path.

    Hth,
    Mike Weaver
     
    Mike Weaver, May 17, 2004
    #5
  6. Jan van de Poel

    thenrich Guest

    The only thing I can see happening is that somehow there is a VBA being loaded then something is being fired in the Open event of the VBA. I'd think that should even be controllable before the drawinf was opened
     
    thenrich, May 17, 2004
    #6
  7. It seems to me that there might be a problem with the dwg itself.
    Why don't you post the dwg in CF so that everyone can have a look
    (Assuming it's 171Kb and NOT 171Mb)
     
    Jorge Jimenez, May 17, 2004
    #7
  8. Jan van de Poel

    Mike Weaver Guest

    From the problem drawing, enter "VBAMAN" at the command prompt. Is there
    anything in the "Projects" list? If the problem is occuring in an OnOpen
    event, as you suspect, then it will have to be in one of the projects listed
    in the "Projects" list. Make a note of each of these projects and it's
    location then hide them by moving them to a folder not found on the acad
    search paths. Now restart Acad and reload this problem dwg. If the problem
    was the vba then it should be gone.

    Mike


    Is the "EXTRACT" button enabled? If so, then pick it, and save the
    resulting dvb file to a safe place *NOT* on the AutoCAD search path.
    loaded then something is being fired in the Open event of the VBA. I'd think
    that should even be controllable before the drawinf was opened
     
    Mike Weaver, May 17, 2004
    #8
  9. Thanks for the responds guys.
    Some remarks:
    1 - The drawing is only 171kb NOT 171mb.
    2 - We do not use 'home made' VBA progs. if there is VBA used it should be
    coming from autodesk.

    I'll post it in the CF group.

    Waiting for your comments.

    Thanks

    Jan
     
    Jan van de Poel, May 18, 2004
    #9
  10. Found the culprit.
    After loading the drawing and using VBAMAN, there was an embedded routine
    running.
    Removed it and saved the dwg.
    After reload the drawing was as fast as it should be (at 171kb).
    Thanks guys, especially Mike Weaver.

    Jan
     
    Jan van de Poel, May 18, 2004
    #10
  11. Jan van de Poel

    thenrich Guest

    Where did the VBA come from if you don't have any in house applications?
     
    thenrich, May 18, 2004
    #11
  12. Jan van de Poel

    Mike Weaver Guest

    Glad to help.
    Autodesk doesn't have any VBA running "out of the box" that I'm aware of,
    and certainly nothing embeded in the drawing files. That has to be done by
    someone in VBA man.

    Mike
     
    Mike Weaver, May 18, 2004
    #12
  13. Maybe embedded in the dwg?(is that possible)
    Or maybe the dwg was that slow because it was constantly looking for that
    app.
    No idea.
    I don't like the VBA stuff, too dangerous(think of macro-virus).

    Jan
     
    Jan van de Poel, May 19, 2004
    #13
  14. Type VBARUN at the commandline then select Options from the dialog. If "Enable macro virus protection" is selected when you open a drawing with an embedded VBA project you should get a choice as to "Disable Macros", "Enable Macros" or "Do Not Load".
    Regards - Nathan
     
    Nathan Taylor, May 19, 2004
    #14
Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.