Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Declared VBA Variables V1.0 RC2 (VBA 6)

    I'm defnitely going to take a look.

    BTW: do you know MZ-Tools? (http://www.mztools.com ) it is a tremendously good utility for VBA programmers!
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  2. #2
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Declared VBA Variables V1.0 RC2 (VBA 6)

    Jan Karel,

    Thanks for taking a look, I do appreciate it.

    Thanks for the pointer to MZTools, but I have used it since the VB5 version. Although a great tool like this can't be mentioned too much.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  3. #3
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List Declared VBA Variables V1.0 RC2 (VBA 6)

    <P ID="edit" class=small>(Edited by carbonnb on 20-Jan-03 09:01. to add the reason why I didn't post it to the lounge.)</P>Last June one of the fine folks on a mailing list I subscribe to asked if there was a way to list the Declared Variables of a VBA project. No one knew of any, so I took on the challenge to write one, mainly so I could learn how to work with the VBE object model, but also to help out this person.

    In September I let that list know about the templates that I wrote that would allow you to do that.

    Well I was having a hard time keeping track of SIX, yes 6 different versions (one for W97, W2K, XL97, XL2K and two for A2K, code that you import and a Menu Add-In), so I decided to give a go at writing a COM Add-In that would do this.

    Well, I have finally finished the COM Add-In and I just wanted to let you all know about it, since it can be a handy tool for VBA programmers. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    It should work in ANY VBE 6 environment that will accept a COM Add-In, IOW, Office 2000 and higher or any application that is VBA6 enabled. I
    have been able to test it in Word, Excel, Access, PowerPoint, Project and FrontPage, all 2000 Versions.

    I have also made a few enhancements from the original code. Exporting the information to Excel as well as to Word, a status bar that lists the number of Projects, Components, Procedures and Variables, icons in the TreeView so you can see what each node is with a visual cue. All these improvements are thanks to our very own <!profile=SammyB>SammyB<!/profile>

    I would love feedback as to what works, what doesn't, what you would like to see, what apps it works in (Office XP particularly, but any
    non-MS product would be great), where it doesn't....

    You can download it from: http://www3.sympatico.ca/carbonnb/bryan/xa...istvbavars.html since it is too big to post in the Lounge.

    I am also including the VB source code, so you can see how I did what I did, if you are interested.

    Let me know what you think or if you have any problems with it.

    And in case anyone is interested, it is free. I don't want anything for it. I have gotten what I wanted out of it. I learned how to work with the VBE. I would like to know what didn't work, or what you'd like to see included, because I want to keep improving this.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

  4. #4
    5 Star Lounger
    Join Date
    Jul 2002
    Location
    Toronto, Ontario, Canada
    Posts
    1,139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Declared VBA Variables V1.0 (VBA 6)

    I just wanted to update this.

    I have released the final version of ListVBAVariables V1.0.

    It includes several bug fixes and minor improvements. THe highlights are:
    <UL><LI>Fixed issue with controls not resizing or moving if form is maximized
    <LI>Added Menu to Main Form
    <LI>Added Export Progress to Status Bar
    <LI>Fixed Issue with lines with quoted strings that were longer than approx 60 characters causing a Stack Overflow error
    <LI>Included File name of VBA Project with Export
    <LI>Added Ability to reuse worksheet/document for Excel exports [/list]It can be downloaded for <img src=/S/free.gif border=0 alt=free width=30 height=15> from http://www3.sympatico.ca/carbonnb/bryan/xa...istvbavars.html

    Any comments. good or bad, suggestions for improvements will be greatly appreciated.
    --
    Bryan Carbonnell - Toronto <img src=/S/flags/Ontario.gif border=0 alt=Ontario width=30 height=18> <img src=/S/flags/Canada.gif border=0 alt=Canada width=30 height=18>
    Unfortunately common sense isn't so common!!
    Visit my website for useful Word, Excel and Access code, templates and Add-Ins

Posting Permissions

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