Software to automatically create folders?

[dirtychinchilla]

Afternoon all,

My boss has asked if I could find something that will automatically create folders on our server based on job numbers. For example, we have a job list (which is currently a spreadsheet) and we input new jobs into this spreadsheet. We then have to go to two different folders, a Drawings folder, and a My Documents folder on the server and create a file with that job number in each place. Unfortunately, he isn't utterly useless at getting this right and wants to know what we can do to automate it.

I'd love to hear any solutions that you might have for me. We are willing to use software or whatever to do it.

Thanks in advance,

dirtychinchilla

 

[BigBoy]

A Batch or Command shell script will do this but I cannot for the life of me think of the lines you will need!

 

[dirtychinchilla]

Thanks for the reply. I had thought as much, but have no clue how such a thing would work.

 

[marc2003]

google "excel create folders"

http://www.extendoffice.com/documents/excel/800-create-folders-based-on-excel.html

 

[dirtychinchilla]

Ah you fantastic person! The only thing is now, for some reason I can't click the Visual Basic button in Excel!! Macros are enabled btw.

 

[dirtychinchilla]

Sorted it, thanks a lot guys.