Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
A couple of months ago I started to create a program in excel, what a magnificant program this is!! I'm learningmore and more about VBA, but I absolutely have no clue how to realize the idea I've got now. The idea is about the versioning of the file. Each time the file is edited the versioning should number op. There are 4 levels of changes that can be made: 1. new functionality 2. Formula editing 3. Formatting the file 4. Data entry The file is named like: file.[level1].[level2]..[level3].[level4]. Example is like - file.1.1.1.1 This means each level on first stage. By calling a macro I want the user to be asked what kind of change has been made or to choose the option "no chages made". This is followed saving the file with numbering up the version number to the right level. (like Save As) The realizing of the numbering has to be made in the excel file (so no external file like .txt). (Optionally with version history where also an comment can be added) If no idea of how to realize this, or where to start. If some of you experts could help me out here, would be GREAT! Thanks in advance, Bernd |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
idea anyone? | Excel Programming | |||
Complicated work! Any idea?? | Excel Programming | |||
Any idea how to work? | Excel Worksheet Functions | |||
Complicated work! Any idea?? | Excel Worksheet Functions | |||
any idea | Excel Programming |