Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
new version# when opening file
Hi,
I need a spreadsheet where a cell (fx."A1") shows the latest report version, i.e. the cell needs to change the version-number from # to #+1, when you open the report. Does anyone know a macro which can do this ? BR, Jakob |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
new version# when opening file
Private Sub Workbook_Open()
With ThisWorkbook.Worksheets("Sheet1").Range("A1") .Value = .Value + 1 End With ThisWorkbook.Save End Sub 'This is workbook event code. 'To input this code, right click on the Excel icon on the worksheet '(or next to the File menu if you maximise your workbooks), 'select View Code from the menu, and paste the code -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Jayjay" wrote in message ... Hi, I need a spreadsheet where a cell (fx."A1") shows the latest report version, i.e. the cell needs to change the version-number from # to #+1, when you open the report. Does anyone know a macro which can do this ? BR, Jakob |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
new version# when opening file
Thanks Bob,
Perfect! "Jayjay" wrote: Hi, I need a spreadsheet where a cell (fx."A1") shows the latest report version, i.e. the cell needs to change the version-number from # to #+1, when you open the report. Does anyone know a macro which can do this ? BR, Jakob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opening .xls in 2007 version | Excel Discussion (Misc queries) | |||
opening newer version of excel | Excel Discussion (Misc queries) | |||
Trouble opening PC version of Workbook on MAC | Excel Programming | |||
Error opening Excel in different version | Excel Discussion (Misc queries) | |||
TROUBLE OPENING OLD WORKBOOK VERSION | Excel Discussion (Misc queries) |