How to get sequential number in worksheet

[Au4848]

I have worksheet called Test.xls. There is a marco called Getdate which is used to get data from other spreedsheet. I want to save this worksheet with some number whenever it saves. Just i would like to have a sequential number to this worksheet.

Thanks

[charlie79]

Might not be the best way, but here's something quick and dirty...

Private Sub Workbook_Open()

Cells(1, 1).Value = Cells(1, 1).Value + 1

End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.SaveAs ("C:test" & Cells(1, 1).Value & ".xls")
End Sub


So every time the workbook is opened, the value in A1 will be incremented by 1. Then, before the workbook is closed, the vba code saves it as test + whatever a1's value is... Might get you started anyway. You could always hide the column or row that holds your incrementing value..