programmatically Update XLA

[ClulessChris]

Is it possible to programmatically update a *.xla file, with a later version of it's self?

Everybody body is somebodys Nutter.

 

[abaldwin]

What do you mean? Are you wanting to deploy a newer version of an existing XLA to your machine, using code in the existing xla or from say installshield?


Andy Baldwin

"Testing is the most overlooked programming language on the books!"

Ask a great question, get a great answer. Ask a vague question, get a vague answer.
Find out how to get great answers FAQ219-2884.

 

[ClulessChris]

I hope to use code in the existing xla to deploy a newer version.

I've found

http://www.jkp-ads.com/articles/updateanaddin.asp

This seems to give some answers, but Ive yet to work my way through it.

Everybody body is somebodys Nutter.

 

[combo]

You could try my old post in this forum: thread707-595209.

combo

 

[ClulessChris]

The method I've settled on is In basic steps:
1.Rename existing add-in project
2.Copy updated file in to the library
3.Prompt user to restart Excel
4.Remove copied file.

Many thanks for all your help

Everybody body is somebodys Nutter.