Best way to save add-in versions

[Prof Wonmug]

I have created a couple of add-in modules. I would like a quick and
easy way to save versions before I make major changes.

With my main documents (Word, Excel, etc.), I make a copy of the file
with a timestamp in the file name. If the document was [test.xlsx], I
make a copy named [test.20100103 1905.xlsx].

I am usually working from Windows Explorer, so this is easy to do. Or
is can use Save As.

With add-in modules, I do not have Explorer open to the add-in folder
[C:\...\Application Data\Microsoft\AddIns] and the VBA editor does not
seem to have a Save As function.

Is there an easy way for me to make a copy of the add-in module with a
modified filename?

[Dave Peterson]

You could create a subroutine that saves the addin as the name you want.

Option Explicit
Sub SaveCopyAsNewName()
dim myFilename as string

'change the path and change test to your addin name
myFilename = "C:\yourpathhere\test" & format(now,"yyyymmdd hhmmss") & ".xls"

thisworkbook.savecopyas filename:=myfilename
End Sub

Then run it whenever you want.

--

Dave Peterson

[Robert Flanagan]

Just copy to another folder using windows explorer and then rename with a
version or date stamp. Other approaches will ultimately cause you
troubles.

Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Prof Wonmug" <won...@e.mcc> wrote in message
news:9u13k55jdv398c9ff...@4ax.com...