Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Generate form for directories?

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi everyone,

    I have some code that will go into every excel file (all formatted the same) and extract data i need to the current worksheet. But i would like to be able to do more, and make it easier.

    Would it be possible to generate a form which looked for all the directories in a given directory, then ask the user to check which directories they wanted to search in. then i could loop my code for all the checked directories?

    My directories are as follows:
    into each year, "YEAR 2001", "YEAR 2002" etc
    Then each year has every month "01-01","02-01" etc...
    Then there are even more directories inside of these. but i just want the check boxes to generate for each month so we can do a report say for the last 3 months or whatever we choose.

    thanks for any help

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm heading home soon, but research userform, chdir, folders, SubFolders, FileName, open. This should get you started in the right path.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Two questions.
    Are you using Office 2000?
    Is everybody who uses this workbook running the same version as you?

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Stockton, California
    Posts
    281
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yes TS Tom, as of right now, myself and everyone else is using office2k, but in the future, that may change to office 2002, I'm not sure.

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
  •