Macro to save duplicate file and create folder name based on cell value

Works perfectly thanks LR

Hello Leith Ross,

I'd like to know if it is possible to create a macro (assigned to a button) that would create a new folder onto this directory:

"\\s009\mimx\DTMS\DTMS_2012\Europa\França\Propostas\Budgets"

and that it's name would be the on the cell

"F9" - eg. "B112-2012".

After that just save a copy of that document onto that directory!


Thanks a lot! http://www.excelforum.com/images/icons/icon7.png

Tiago