Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create folders in explorer from an excel list
I have a list in excel of names each of which need a folder created in
exlorer. Is there a way to do this? Can't find anything relevant in Help |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create folders in explorer from an excel list
Let's say the list of names is in column B in B1 thru B100. In column A
enter mkdir in cells A1 thru A100. Save the file as a text file with the name: x.bat Then just double-click the resulting icon. -- Gary's Student "njmcr" wrote: I have a list in excel of names each of which need a folder created in exlorer. Is there a way to do this? Can't find anything relevant in Help |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create folders in explorer from an excel list
Thanks for the reply.. just a question tho.. what file do I save as x.bat?
the excel spreadsheet? Sorry... I need real 'for non technical person' instructions "Gary''s Student" wrote: Let's say the list of names is in column B in B1 thru B100. In column A enter mkdir in cells A1 thru A100. Save the file as a text file with the name: x.bat Then just double-click the resulting icon. -- Gary's Student "njmcr" wrote: I have a list in excel of names each of which need a folder created in exlorer. Is there a way to do this? Can't find anything relevant in Help |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create folders in explorer from an excel list
right I actually have the MS DOS Batch file on my desk top now... how do I
see the folders in explorer?? Sorry for the simply questions... "njmcr" wrote: Thanks for the reply.. just a question tho.. what file do I save as x.bat? the excel spreadsheet? Sorry... I need real 'for non technical person' instructions "Gary''s Student" wrote: Let's say the list of names is in column B in B1 thru B100. In column A enter mkdir in cells A1 thru A100. Save the file as a text file with the name: x.bat Then just double-click the resulting icon. -- Gary's Student "njmcr" wrote: I have a list in excel of names each of which need a folder created in exlorer. Is there a way to do this? Can't find anything relevant in Help |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I create folders in explorer from an excel list
Don't be concerned about asking simple questions.
If you see the batch file on your desktop, double-click it. The batch file should then execute and generate a set of folders ( probably also on your desktop). You can then use Windows Explorer to display the Desktop and the folders should be visible. -- Gary''s Student "njmcr" wrote: right I actually have the MS DOS Batch file on my desk top now... how do I see the folders in explorer?? Sorry for the simply questions... "njmcr" wrote: Thanks for the reply.. just a question tho.. what file do I save as x.bat? the excel spreadsheet? Sorry... I need real 'for non technical person' instructions "Gary''s Student" wrote: Let's say the list of names is in column B in B1 thru B100. In column A enter mkdir in cells A1 thru A100. Save the file as a text file with the name: x.bat Then just double-click the resulting icon. -- Gary's Student "njmcr" wrote: I have a list in excel of names each of which need a folder created in exlorer. Is there a way to do this? Can't find anything relevant in Help |
#6
|
|||
|
|||
This works brilliantly with single file names. Do you know how I can adjust the formula to accept file names with a "space"? ie Nathan Black
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can anyone help me Create Excel list of files in windows folders | Excel Worksheet Functions | |||
How do I create multiple columns from a one-column list in Excel? | Excel Worksheet Functions | |||
How do I create a mailing list with current data in Excel? | Excel Discussion (Misc queries) | |||
If I create a random list in Excel, does it repeat numbers? | Excel Worksheet Functions | |||
how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) |