I have an Excel 2007 workbook that I use daily, and I typically make a point to save a copy of it as a '97 workbook so that I can use it at my work place (yes, my employer sees no need to upgrade to 2007).
So a dilemma occurs when I forget to save this workbook as a '97 workbook on my PC at home to transport with me to work. One solution is to work strictly in '97 at home, but I do not have it installed on my home PC, nor do I want to have it installed. I like 2007. I want to learn VBA in 2007.
My question: is there a way for my 2007 workbook to automatically duplicate itself as a '97 workbook every time I save changes and/or close my 2007 workbook?
edit: By saving as a '97 workbook, what I mean is saving it as a 97-2003 workbook.
Bookmarks