Author Topic: VBA equivalent for VB's App.Instance  (Read 2068 times)

0 Members and 1 Guest are viewing this topic.

Guest

  • Guest
VBA equivalent for VB's App.Instance
« on: December 13, 2006, 11:58:40 AM »
Just as the subject says, is there an equivalent for VB's App.Instance and if so, what is it?

Thanks.

David Hall

  • Automatic Duh Generator
  • King Gator
  • Posts: 4075
Re: VBA equivalent for VB's App.Instance
« Reply #1 on: December 13, 2006, 12:08:10 PM »
I couldn't find anything in VBA or Google
Everyone has a photographic memory, Some just don't have film.
They say money can't buy happiness, but it can buy Bacon and that's a close second.
Sometimes the question is more important than the answer. (Thanks Kerry for reminding me)

Guest

  • Guest
Re: VBA equivalent for VB's App.Instance
« Reply #2 on: December 13, 2006, 12:12:35 PM »
I came up empty as well.  I was hoping maybe someone had something tucked away somewhere.

I'm gonna keep sniffin' around.

Chuck Gabriel

  • Guest
Re: VBA equivalent for VB's App.Instance
« Reply #3 on: December 13, 2006, 12:17:35 PM »
What exactly are you up to?

Guest

  • Guest
Re: VBA equivalent for VB's App.Instance
« Reply #4 on: December 13, 2006, 12:33:18 PM »
I'm trying to get some VB code working for VBA.  Specifically, balloon tooltips.  Here's the original code.

Chuck Gabriel

  • Guest
Re: VBA equivalent for VB's App.Instance
« Reply #5 on: December 13, 2006, 12:54:46 PM »
I think you might be able to substitute the pseudohandle returned by the GetCurrentProcess WIN32 API function in place of App.hInstance in the call to CreateWindowEx in clsToolTip.