Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to store VBA code examples?

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, I've been collection VBA samples from various places but sometimes forget what file something is in.

    Has anyone written a script to open every spreaadheet in a directory, and copy the names of all of the subroutines (and any immediately following comments) to a workbook?

    Same thing for all sheet names?

    I could do this myself, so you only need to reply if you have something similar already : ie.
    1) cycles through all files in a folder
    2) cycles through all VBA subroutines and functions in a file.

    Regards

    Brian
    BW-NoSPAM1@earthlink.com

    (I tried to post this earlier today but it dod not show up on the board.)


  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am sucking eggs but////////////////


    Export as BAS files and thats that o Ok yxy is col

    i would load intio personal Xls ..

    noy to many array or udf fle funcions thou:

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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