Try
ChDir "C:\My documents\Invoices"
MkDir Format(Now, "mmm-yy")
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl
"Jeff Marshall" wrote in message ...
Hi ,
I have a cell(1,1) that has the text "Sept" in it and cell(1,2) has "03" in
it.
Is there a way to make a folder in C:\My documents\Invoices, that would name
the folder "Sept-03" ?
(I would like to make a macro that I run once a month that would make this
new folder naming it the month and year so I could save invoices made out to
different companies to it)
Thanks in advance for any help offered.
Jeff Marshall x23