ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   macro save a workbook whilst increasing file no (https://www.excelbanter.com/excel-worksheet-functions/54737-macro-save-workbook-whilst-increasing-file-no.html)

shrek

macro save a workbook whilst increasing file no
 
Im trying to set up a macro so that I can save a worksheet using a macro 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 when I save the worksheet a 2nd time I need it to save as book2.xls and so on.
Also before I save the workbook I need it to break the special Link. I think this is right I was going to save by breaking link first by using edit links and breaking then save as the workbook no. What I need help with is how to increase the workbook no by one each time I save it using the macro so I do not have to input the no everytime. I have to save the same workbook every month but with different data in it. This is why I need to save as book1.xls, book2 etc etc

Can anyone help.

Many Thanks


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com