View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Using VBA in Excel to Make a Folder to Save Workbooks in

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