UDF and PERSONAL.XLS

hatman

Well-known Member

Joined

Apr 8, 2005

Messages

2,664

• Oct 26, 2007

• #2

I HIGHLY recommend placing all UDF's and custom generic toolbar procedures in one or more Addins. This makes them available to all workbooks and provides portability, allowing you to more easily install, uninstall and share with others.

 

Upvote 0

Greg Truby

MrExcel MVP

Joined

Jun 19, 2002

Messages

10,025

• Oct 26, 2007

• #3

Schielrn, not stalking you, I swear... (I'm stalking hatman )

I second what Paul says about add-ins. Tushar recommends a complete segregation of data and code, i.e. always put code in Add-In's, never in data-containing workbooks. I'm afraid I am not quite that pure in my programming. But I do keep my most commonly used UDF's in my own Add-In. I try to keep similar functions grouped into modules. Then if I need to grab a "pack of functions" I can either drag the module from my add-in to whatever project needs them. Or I export the module, so that I can easily import the code if I am creating workbooks and adding code to them programmatically through the VBIDE.

HTH,

 

Upvote 0

hatman

Well-known Member

Joined

Apr 8, 2005

Messages

2,664

• Oct 26, 2007

• #4

Hey Greg... why are you following me? I'm not THAT irresistible.

BTW: if you are so inclined, Laurent Longre has built a .dll that will even make your UDF's look native, by making them play nicely with the Function Wizard. It's NOT the most user friendly piece of coding, but once you have it working, it REALLY makes your functions look professional.

http://xcell05.free.fr/english/

Edit: Typoed and left out the word NOT above... sorta changes the meaning of the whole post

 

Upvote 0

schielrn

Well-known Member

Joined

Apr 4, 2007

Messages

6,941

• Oct 26, 2007

• #5

Hey hatman thanks for that link. That is really nice. And thank you both for the responses. I don't mind you stalking my posts Greg, you've always been of great assistance.

 

Upvote 0

hatman

Well-known Member

Joined

Apr 8, 2005

Messages

2,664

• Oct 26, 2007

• #6

I don't mind you stalking my posts Greg, you've always been of great assistance.

Click to expand...

Yeah, Greg can be a little rough around the edges, but he cuddly - I mean helpful - enough that we keep him around anyway.

If you need help building your addins, just ask.. it can be tricky the first time, though there are certainly enough articles and sicussions floating around to be helpful.

 

Upvote 0

schielrn

Well-known Member

Joined

Apr 4, 2007

Messages

6,941

• Oct 26, 2007

• #7

Building the add-in was fine and I have all my UDFs in it, now if I want to add some later, can I just open the xla file and add them to the module and then save. Would the already installed add-in automatically update with those new functions?

 

Upvote 0

hatman

Well-known Member

Joined

Apr 8, 2005

Messages

2,664

• Oct 26, 2007

• #8

Yes, that is correct. Just make sure that you save from the VBE, and that you are in the proper file. In this way, the Addins behave just like the Personal.xls, however, the addins tend to be more stable...

 

Upvote 0

schielrn

Well-known Member

Joined

Apr 4, 2007

Messages

6,941

• Oct 26, 2007

• #9

Ok thanks that was a lot of help. Every day I keep picking up more and more maybe soon enough I may reach your level.

 

Upvote 0

hatman

Well-known Member

Joined

Apr 8, 2005

Messages

2,664

• Oct 26, 2007

• #10

Hey, I'm still trying to reach Greg's level, and if you ask him, he's still trying to meet someone else's level (insert appropriate guru here). We all have things to learn, which is why we hang out in this particular community.

 

Upvote 0