No portability with UDFs

[Godster]

Hi all,
Long time reader, first time poster.

I have created a macro workbook that sits on our server that various users on different computers need to be able to open.
I have solid (if self-taught) experience with VBA code, UDFs, etc.,, but very little experience with creating, setting up or managing Add-ins.

I need a ground-up tutorial on this (more so than the usual "... go to Options, select Add-ins, click Go..." walk-through!). At least if I can get a real intro to the process I will be able to frame a more articulate question to the forum on this (if I can't solve it myself).

What do people recommend re thorough introduction to creating, setting up and managing Add-ins?

Thanks in advance.

 

[Fazza]

hi & welcome

I learnt from a John Walkenbach book, "Excel 2000 Power Programming wtih VBA" and can recommend that. I assume any good Excel VBA book will also be suitable.

I've also (first edition, now superseded of) "Professional Excel Development" by Stephen Bullen, Rob Bovey & John Green. A first class book.

There are endless on line resources.

Suggest you dive in to the task and if/when you have further questions just ask again - if google doesn't get you the answer. With a little familiarity they are simple enough.

regards

 

[Pilule]

I have the same problems, can I get a walk thru on how to fix that?