+ Reply to Thread
Results 1 to 23 of 23

MkDir with cell value as folder name.

  1. 08-23-2012, 04:18 AM #1
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    MkDir with cell value as folder name.

    Hi all i need urgent help creating folders with the cell value as folder name.

    I tried but did not sucseed, the folders needs to be created in a folder on my desctop.
    Thanks


    The File with the data is attached.

    FR Catai Assets Final 23-08-2012.xlsm
    Reply With QuoteRegister To Reply
  2. 08-23-2012, 04:26 AM #2
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: MkDir with cell value as folder name.

    Try this 

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  3. 08-23-2012, 04:29 AM #3
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-23-2012, 04:55 AM #4
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    With the first one i recive the following error.

    What did i do wrong?
    Error.xlsx
    Reply With QuoteRegister To Reply
  5. 08-23-2012, 05:23 AM #5
    mike7952
    mike7952 is offline
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: MkDir with cell value as folder name.

    Need to change C:\to your desktop path. Or use Bobs that will get your desktop path for you.
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 08-23-2012, 05:29 AM #6
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    Fixed
    Thanks
    Reply With QuoteRegister To Reply
  7. 08-23-2012, 06:33 AM #7
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    I now need to go a step futher, i need a folder for each month in each folder.

    At the moment my macro is like this:

    Please Login or Register  to view this content.
    How do I need to change it now?

    Thanks for the help!

    FR Catai Assets Final 23-08-2012.xlsm
    Last edited by Cutter; 08-23-2012 at 12:46 PM. Reason: Added code tags
    Reply With QuoteRegister To Reply
  8. 08-23-2012, 06:38 AM #8
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name.

    Where does C:\test align to your request for the desktop?
    Reply With QuoteRegister To Reply
  9. 08-23-2012, 06:44 AM #9
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    I just made a folder on my c drive, sorry.
    Reply With QuoteRegister To Reply
  10. 08-23-2012, 06:45 AM #10
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  11. 08-23-2012, 07:17 AM #11
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    Nothing happens, the macro run with no error,but nothing happens?
    Last edited by Cutter; 08-23-2012 at 12:47 PM. Reason: Removed whole post quote
    Reply With QuoteRegister To Reply
  12. 08-23-2012, 07:29 AM #12
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name.

    Is this any better?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  13. 08-23-2012, 07:38 AM #13
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    Sorry but where will make the folders, as the test folder is still empty?
    Last edited by Cutter; 08-23-2012 at 12:47 PM. Reason: Removed whole post quote
    Reply With QuoteRegister To Reply
  14. 08-23-2012, 07:57 AM #14
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    My macro looks like this.
    Please Login or Register  to view this content.
    Last edited by Cutter; 08-23-2012 at 12:48 PM. Reason: Added code tags
    Reply With QuoteRegister To Reply
  15. 08-23-2012, 09:28 AM #15
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    Can anybody help me?
    Reply With QuoteRegister To Reply
  16. 08-23-2012, 12:49 PM #16
    Cutter
    Cutter is offline
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: MkDir with cell value as folder name.

    @ tdo4h

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

    Also
    Please notice that I have removed whole post quotes from your posts(s). Please read the following forum rule and keep it in mind for your future posts. Thanks.

    Rule 12. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
    Reply With QuoteRegister To Reply
  17. 08-24-2012, 02:18 AM #17
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    Please Any body, i need this to work.
    Thanks
    Reply With QuoteRegister To Reply
  18. 08-24-2012, 04:29 AM #18
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name.

    Presumably there is an error. Remove the line that says On Error Resume Next and tell us where it errors and what the error is. Get the value of path as well, and your desktop folder.
    Reply With QuoteRegister To Reply
  19. 08-24-2012, 04:39 AM #19
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    The Macro run with out any error, it but it did not create any folders?
    Thanks

    ---------- Post added at 10:39 AM ---------- Previous post was at 10:38 AM ----------

    The macro that Mike posted worked, now i just need to make folders in the folder, a folder per month.
    Thanks
    Reply With QuoteRegister To Reply
  20. 08-24-2012, 05:55 AM #20
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name.

    I know that, but there is an error ignore statement, which is what I suggested that you remove and re-run.
    Reply With QuoteRegister To Reply
  21. 08-24-2012, 06:29 AM #21
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    Thanks, the error that I recive is :Run-time error '76' Path not found

    Please be patient with me, as I am new to this, and not used to the forum rule's, but will do my best to obey them.
    Thanks.
    Reply With QuoteRegister To Reply
  22. 08-24-2012, 06:32 AM #22
    Bob Phillips
    Bob Phillips is offline
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: MkDir with cell value as folder name.

    I am being patient, trust me

    What was the value of path when the error arose, and what is the full value of your desktop folder (e.g. mine is C:\Users\bob\Desktop)?
    Reply With QuoteRegister To Reply
  23. 08-24-2012, 06:37 AM #23
    tdo4h
    tdo4h is offline
    Registered User
    Join Date
    08-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    34

    Re: MkDir with cell value as folder name.

    MkDir path & cell2.Value & "\" & cell.Value
    My full value is C:\User\Sarel Snyman\Desktop.

    Thanks
    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)

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