Hi All,
This may not exactly be an Excel question but it is related to Excel. A friend of mine told me it is possible to create multiple file folders (in your Windows Explorer) using a list from Excel.
For instance, I have in Column A approximately 100 different names. Say I have a folder called "Blocks" on my C drive (we'll say C:\Blocks), is it in fact possible to use that Excel list to automatically generate (with names) the 100 folders?
open a new workbook
put this code in a new module
(see where to put code at bottom of this post)
save the workbook to say C:\Blocks
Please Login or Register to view this content.
put your list in say column a
select list
then run macro from tools/macro/macros
(it will be in list as "MakeFolders" )
alternatively you could add it to your existing workbook and save that in C:\Blocks and run
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks