Who uses Personal.xls?

[TinaP]

One thing I'm working on at the moment is an addin that needs to go on quite a wide distribution. The plan is to include a routine that looks at the addin version # and see if it is the same version # as the master on a specific directory. If a newer version exists (on a per module basis actually), then it removes the old one and imports the new one. I've not done this before but I know Mikey B has had some success with a similar process before...

I'd be very interested in that. I hope you plan to post your code here.

 

[SuperFerret]

If anyone knows of a good write-up on the web on Add-Ins, please pass it along, and I will check it out in my spare time!

I should probably learn as well, my story is much the same, but probably with more sub standard macro's than any of you guys!

I just know when I'm relieved of everyone elses jobs (when people come back from maternity) I'll be asked to set them up the big 3.
Hopefully by that time I'll have enhanced my VBA skills and have learnt how to make them into an add-in!

 

[RoryA]

Jon,
Have you read this?

 

[Colin Legg]

Hi Joe,

Add-ins (I mean .xla / .xlam in this context) are not without their own set of problems.

When an add-in is shared amongst users there are two important tricks in relation to updating it:

(1) Making sure all users are using the correct, shared version (when installed it is not copied to their local drive)
(2) Making sure all users have read-only access


Ken Puls wrote a really good article here:
http://www.excelguru.ca/node/45

 

[Colin Legg]

Jon,
Have you read this?

Oh man... same link as mine! Now it looks like I copied you.

 

[RoryA]

Welcome to Richard's club.

 

[Domski]

I use personal.xls for functions and code that pretty much only I will or should use.

I use add-ins for distributing things to other people generally although I have got a couple I've thought worth creating for my own use.

Pint of G&T, a nice steak and a bottle of Chateauneuf du Pape for this stellar contribution please

Dom

 

[Richard Schollar]

Welcome to the Plagiarist Crew! Colin you are the third member after me and Andrew Poulsom! You now have to buy me a further round of beer!

 

[Joe4]

Thanks for the links on those. Learning how to create Add-Ins is one of those things that has been on my mental "to do" list for about five years now. No excuses for me anymore!

Just have to find the time to do it now (still trying to catch-up at work after last week's vacaction!).

 

[Domski]

A recent post along these lines: http://www.mrexcel.com/forum/showthread.php?t=482674

Not sure about the library.xls idea.

Dom