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?
|