macro save a workbook whilst increasing file no

S

shrek

Im trying to set up a macro so that I can save a worksheet using a macr
and it increases the workbook no by one each time its saved.
I.E use macro button first time and it will save as book1.xls and whe
I save the worksheet a 2nd time I need it to save as book2.xls and s
on.
Also before I save the workbook I need it to break the special Link.
think this is right I was going to save by breaking link first by usin
edit links and breaking then save as the workbook no. What I need hel
with is how to increase the workbook no by one each time I save i
using the macro so I do not have to input the no everytime. I have t
save the same workbook every month but with different data in it. Thi
is why I need to save as book1.xls, book2 etc etc

Can anyone help.

Many Thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code does as instructed, but creates and saves a Book1 2
Getting Radio Buttons to work, that are inserted via AutoText 0
Password locked with macro 1
Run code from another workbook 7
Macro to save and close, then copy file 2
Stop Macro running when I save the workbook 1
Macros 2
Linked Cells, Increment Sheet Number Ref. 3

Top