View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Matt
 
Posts: n/a
Default Values to a folder name on desktop

I followed your procedure and after double clicking on the .BAT file dos
performed something but the folders were not created ..... any other ideas?

"Chris Marlow" wrote:

Matt,

When I need to do something like this quick and dirty (rather than something
I think will be repeated - where I'd probably delve into code) I do something
like this (say my names are in column A & I'm adding to all users desktop);

1) Write a formula ="mkdir ""C:\Documents and Settings\All
Users\Desktop\"&A1&"""" and drag down as needed.
2) Drop the contents into notepad & save as something.BAT
3) Find something.BAT in Explorer & double click (or use command line - same
difference).

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"Matt" wrote:

I have a spreadsheet with 2200 names on it, and I would like to create a
folder (on my desktop, or hard drive) for each individual one without
creating them one and a time 2200 times. Does anyone know how to do this?