+ Reply to Thread
Results 1 to 4 of 4

Macro to list subfolders only, no file

  1. 04-01-2014, 01:45 AM #1
    JJGF
    JJGF is offline
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Macro to list subfolders only, no file

    I have this code which works but the first 2 entries that the macro lists in cell A1 is . and cell A2 is ..
    Any way to correct this?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 04-01-2014, 02:43 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Macro to list subfolders only, no file

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 04-01-2014, 05:22 AM #3
    apo
    apo is offline
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: Macro to list subfolders only, no file

    and this..

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 04-01-2014, 12:54 PM #4
    JJGF
    JJGF is offline
    Forum Contributor
    Join Date
    12-06-2012
    Location
    sacramento,calif
    MS-Off Ver
    Excel 2010
    Posts
    217

    Re: Macro to list subfolders only, no file

    AlphaFrog works great, thanks
    apo, yours works too but causes a cmd window to appear
    Last edited by JJGF; 04-01-2014 at 12:58 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA code needed to move from Outlook 2010 subfolder to Symantec Vault subfolder
    By Marijke in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 01-09-2014, 12:14 PM
  2. [SOLVED] Mkdir command button to add subfolder/subfolder
    By frefry4 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-17-2013, 06:28 PM
  3. To have flexibility to open workbook file on a specific drive\subfolder.
    By anneypng in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2012, 01:30 AM
  4. Moving an e-mail from a subfolder in Mailbox to the equivalent subfolder in an archive PST
    By johncassell in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 07-09-2012, 11:31 AM
  5. [SOLVED] Cloning a file in a subfolder multiple times using VBA - possible?
    By Smeddlesboy in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-06-2012, 11:17 AM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1