Efficent VBA Code - Variable & Memory Questions

Discussion in 'AutoCAD' started by Oberer, Jan 28, 2005.

  1. Oberer

    Oberer Guest

    I'm asking for some verification & clarification on a couple of codiing questions...

    1) I've always heard that it's more efficent to to process as few "."'s as possible. In other words, set a referenced to ThisDrawing.Blocks if using a for/each loop.

    Example:
    For each oBlock in ThisDrawing.Blocks vs
    next
    set Blocks = ThisDrawing.Blocks
    For each oBlock in Blocks
    next

    However, I see plenty of code (and no suggestions to "tighten it up") that make liberal use of extended hiearchies.

    2)"Releasing Variables" - I've always taken the time to Set ObjectVar = Nothing at the end. i rarely see this, and i know it's supposed to happen by default. is this a waste of time?
     
    Oberer, Jan 28, 2005
    #1
  2. Oberer

    Frank Oquendo Guest

    Let's face it: if you have to squeeze every last drop of performance out
    of your application, you won't be using VB or VBA.
    Mechanically speaking, yes. However, the benefit is clarity and that's
    hardly a waste of time.
     
    Frank Oquendo, Jan 29, 2005
    #2
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.
Similar Threads

  1. defining a TCL variable for a part of variable name

  2. How to load efficiently load a file into a variable (memory)?

  3. A couple of DXF code questions

  4. VB/VBA, AutoCAD & Memory

  5. Does VBA Consume Memory ???

  6. Opening files in AutoCAD with VBA and Plotting with LISP command in memory.

  7. Object Variable or With Block variable not set

  8. Run Excel VBA code from AutoCAD VBA code

Loading...