Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    New Zealand
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA Code Formatter? (Office 2000)

    I Keep seeing lots of nice add-in tools for VB6 etc for, amongst other things, formatting code and analyzing code for errors/ dead code etc. See <A target="_blank" HREF=http://ww.aivosto.com>Aivosto's VBShop</A> for some excellent examples).

    Does anyone know of any VBA add-ins along these lines?

    Thanks,
    Kevin <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA Code Formatter? (Office 2000)

    VBACodePrint, from <A target="_blank" HREF=http://www.starprint2000.com>http://www.starprint2ooo.com</A> will handle formatting code, and the VBA compiler should find most code errors. You'll have to define "dead code, etc." for us.
    Charlotte

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    New Zealand
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Code Formatter? (Office 2000)

    Thanks for this info on StarPrint - just what I ws looking for.

    Dead code is just code (or variables) that never actually get used. Aivostos VB Project Analyzer finds all this and more - it just doesn't work with VBA.

    Cheers,
    Kevin

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA Code Formatter? (Office 2000)

    Well, the<A target="_blank" HREF=http://www.fmsinc.com>http://www.fmsinc.com</A> site has tools like that for Access, but I haven't looked for similar tools for other VBA clients.
    Charlotte

  5. #5
    New Lounger
    Join Date
    Jan 2001
    Location
    New Zealand
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA Code Formatter? (Office 2000)

    Thanks again, Charlotte,

    Just for the record, <A target="_blank" HREF=http://www.fmsinc.com>Total Visual CodeTools 2000 </A> does support VBA in all of the Office 2000 apps. <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    Cheers,
    Kevin

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VBA Code Formatter? (Office 2000)

    Great! Glad to have been of help.
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •