Written by our staff of Microsoft MVP's, authors, andĮxperienced developers, much of this code can't be found anywhere else. I am thinking about accessing repository remotely and querying database or what ever, still researching that part.Total Visual SourceBook is the most extensive professional source code library for Microsoft Access, Office, VBA, and Visual Basic 6.0. I have no clue how to access repository in any other way then with svn.exe. Getting tag is a problem, as i have folder in folder, so in the end we could have around 40 or even more svn executes, which would make my tag function very slow.

For svn command to execute it lasts around 0.15-0.20 of a second, so my revision number gathering lasts around 2 seconds.

With svn list -verbose i also got revision number. Īs you see in the end, in my code svn command was executed 13 times so file in repository was found. I was using ShellAndWait('cmd.exe /c svn list -verbose http:\localhost runk > text.txt'), parse that text file to get folders in trunk, then checked which files are in those folders (with another ShellAndWait for each folder), if they were found get revision number and so on. I already made a macro that does the exact thing, but the problem is it's very slow. branches (probably won't get used, not sure yet).Software_Configuration_Management_Plan.docx.System_Requirements_Specifications.docx.write it in excel sheet and also make a hyperlink to that file in another column. Macro that will search for the file on repository, if found read it's revision,tag (latest). official release will be made.Įvery file will have it's place in MS Excel WorkSheet Column with data like: Phase, Name, Revision, Tag, Hyperlink. Those files will be saved in different folders (further on i will make repository structure), folders will have the function of a phase we are currently on in our project (we will have around 12 folders). docx files (all files are already known), for version control we will use SVN. On our project we will have to have some kind of documentation management control.

Kinda the first post ever regarding programming, since till now i managed to google everything that i needed.

Repository of excel vba examples