UDF and PERSONAL.XLS

[schielrn]

Ok as you can tell from my past couple posts, I am trying to streamline some of my macros and UDFs and make them accessible to all workbooks. This is fine for now through the PERSONAL.XLS file. The only problem I have is with the UDFs. Is there somewhere else I can put these that I do not have to type in PERSONAL.XLS before each UDF from that file. Can I move these into the funcres project and have any more sucess or is that just an all around bad idea?

Thanks for any input.

 

[Greg Truby]

...and if you ask him, he's still trying to meet someone else's level (insert appropriate guru here).
~hatman

Yeah, I'd love to be as good as Tom (Right-Click) or Ivan at WinAPI stuff, or Nate at cross-platform stuff, or Aladin or Barry or Dom at formulae. Or Jon P. at charts. Or Andrew or Denis at Access. Fairwinds & Juan Pablo are both very good "all-arounders". That's just a short list of those that I know are better'n me in something that I can think of off the top of my head... were I to really sit down and ponder it, I'm sure the list would be long. This site has one of the deepest benches of gurus I've ever seen. And there are dozens whom I would say are on par with myself (not really "gurus" but can defend ourselves pretty well).

 

[hatman]

And there are dozens whom I would say are on par with myself (not really "gurus" but can defend ourselves pretty well).

But it's still a relief when someone comes along and bails us out with a more elegant solution. I usually try to answer "easy" questions so the gurus can concentrate on the hard ones that are beyond me... but all too often I find myself in deeper than I expected, which always yields a learning opportunity as I either figure it out for the OP, or someone smarter (like Greg, or Right_click, or Barry, Aladin, or Norie) comes along and makes it look easy.

Trust me, the longer you stick around, the more you'll pick up...