version control

Hi there! Anyone facing the problem of version control in Excel? (losing overview about which files are the newest ones......) I'm currently trying to come up with a solution to this problem (master thesis) and would thus love to understand the problem more thoroughly. Is anyone willing to...

Hi All, I'm in need of some Vba help (As usual) :) Id like to implement a version tracker into my spreadsheet. Basically, I have a workbook with multiple sheets, when I update any cell on the "communication plan" sheet id like a box to pop up that says something like "Changes will...

Hi, I manage an area with quite a number of VBA workbooks floating around. Everyone seems to be editing these on the fly and creating more workbooks coding from scratch but steeling (copy paste) from other workbooks. Can someone please refer me to a process, body of knowledge or other that can...

I have a piece of code which copies a worksheet from an Excel workbook and saves this as a text file with the file path and file name being dynamically pulled from two cells. I want to know how to adjust this code so when the file already exists a new version will be saved. Ie: Initially the...

I'm trying to check how many files are in a directory, increment the count each time then put that count in my file name. I'm having trouble with the loop. I can kinda see what the reason is, it looks like it's not counting each file but possibly saying on the same one. Any ideas from the...

I'm working with a client who has had version-control issues with their financial models. I created a button so that the workbook saves with a version number and date into a specified folder. I'd like for this to be the only way to save the workbook. I used the code in the ThisWorkbook...

Hello, I noticed that the Microsoft Date and Time picker is unavailable on Excel 2007 (they use something else, that of course doesn't exist in 2010). Is there something like this available in the default Excel ActiveX controls that can be used in both Excel 2007 and 2010?

Dear all Mr Excel Gurus, I am attempting to build a workbook, which will be continually updated. However, I would like to be able to keep each and every version of the workbook that is saved. I can obviously set a macro to encourage everyone to Save As, rather than just save over the top...

how can i specify the modules i want removed and then also import that same list without having a line for each one. ex currently doesnt work: ActiveWorkbook.VBProject.VBComponents.Remove ActiveWorkbook.VBProject.VBComponents(("AccountDetails"), ("Async"), ("BrentSyncButton"), ("Calculators")...