Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    603

    Unanswered: Use VBA to programmatically list VBA functions . . .

    Looking to programmatically build a list of VBA functions, much like the list that displays when you go into the VBA coding application (within Access), and you pull down the View menubar and select Object Browser, then select the VBA library, and select the Math or Strings collection.

    In my mind this should be something like being able to build a list of forms, reports, modules, etc.

    I've tried addressing these collections with all kinds of object types, but been unsuccessful.

    Is anyone out there able to do something like this?

    Thank you.

    Ken
    Last edited by PracticalProgram; 01-25-17 at 13:25. Reason: Typo
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    630
    Provided Answers: 34
    Export the code to text files.
    In window explorer , run a search for 'Public Sub' (and/or Private)
    The list will show. You could pipe the results to another text file

  3. #3
    Join Date
    Sep 2001
    Location
    Chicago, Illinois, USA
    Posts
    603
    Quote Originally Posted by ranman256 View Post
    Export the code to text files.
    In window explorer , run a search for 'Public Sub' (and/or Private)
    The list will show. You could pipe the results to another text file
    Thanks ranman . . .

    . . . but I don't want to know the names of the functions/subs that I have created . . . I want to know the function names of the VBA built-in functions.

    Things like: nz, left, right, mid, instr, lcase, abs . . . etc., etc., etc.

    And, as my original post stated, I want to do this programmatically, not copy and paste.

    Ken
    Ken

    Maverick Software Design

    (847) 864-3600 x2

  4. #4
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    630
    Provided Answers: 34
    No. Not possible.
    Use google and the vb knowledge base.

Posting Permissions

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