+ Reply to Thread
Results 1 to 2 of 2

create folder with some conditions

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    create folder with some conditions

    Hi all
    i have a problem and i hope you should help me.
    Attached there is a file with a macro that create folders using data in file that i download from this forum (but i dont remember from where).
    The macro function perfectly but i need some more help.
    I need to create folders that answer to some conditions (the cell woth "XXX" value).
    Is it possible to do that.
    Is it also possible copy some specified file in this new folder.
    Thanks
    Attached Files Attached Files

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: create folder with some conditions

    I think you answered yourself to your first question as your macro ptest is working just like you ask by creating folders with name by the cells contents. If it does not work properly, it is possibly because of the path defined in your string. I tested it with a simple path as C:\ and it works just fine.

    For your second question, look at the MSDN site of Windows at:
    http://msdn.microsoft.com/en-us/libr...(v=vs.85).aspx

    You'll find all methods available.
    Last edited by p24leclerc; 07-28-2011 at 10:46 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1