Creating folders from Excel Columns

[patrickrobins]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Every week I have multiple sheets that I need to make folders from. The info I need is in a concatenated column. Example:

1234Shoe blue
4567bag red
etc...

and this goes on for over 100 items. Each one needs to be a different folder. Is there a way to automate this and not just copy and paste each one?

 

[XinXin]

Since XL2008 doesn't support VBA, using AppleScript is an option.

Thanks,
XinXin Liu
Macintosh Business Unit, Microsoft

 

[John McGhie]

Absolutely! This is a job for the Command Line.

Hop into Terminal, and away you go...

See here for the basics:
http://infohost.nmt.edu/tcc/help/unix/mkdir.html

You need to cause Excel to save your sheet out as a Text file, formatted
with a "mkdir" command at the front of each line, so you can just paste it
into Terminal and hit Enter.

Hope this helps

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Every
week I have multiple sheets that I need to make folders from. The info I need
is in a concatenated column. Example:

1234Shoe blue
4567bag red
etc...

and this goes on for over 100 items. Each one needs to be a different folder.
Is there a way to automate this and not just copy and paste each one?

This email is my business email -- Please do not email me about forum
matters unless you intend to pay!