How to create a macro that saves a spreadsheet under a new name

[Jonseya]

Hi

Could anybody help me with a problem, I am trying to create a macro in an excel spreadsheet that will save the file under a certain name but each time the macro is run it incriments the number each time. i.e. the first time the file is run it will be Part1.xls then part2.xls and then part3.xlsetc.

 

[xlbo]

please post this in the VBA forum (Forum707)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question