View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Automatic installer or what for distributing a template?

You may want to look at Kill in VBA's help (well, if you want to delete the
original file).

dk_ wrote:

Ron,

Solution accomplished for installing and also for replacing existing an
excel template...

I changed your code from "Name" to "FileCopy" and then adjusted the
destination location to copy to.

Ron, Thank you very much for your help, inspiration and your time. This
has been fun.

Thank you again.

-Dennis

In article
,
dk_ wrote:

Ron,

Looking extremely good!

Your code works as is.


Now, would you add ONE MORE feature to this code??? :)

I'd like the installer workbook to be able to replace and 'existing'
template with the same name, (as does your original email-sheet
installer).

This way the code can be used for updating to a 'latest version' of the
template.


--

Dave Peterson