idea which I don't know how to work out
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
|