TheSwamp

Code Red => VB(A) => Topic started by: Guest on December 13, 2006, 11:58:40 AM

Title: VBA equivalent for VB's App.Instance
Post by: Guest 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.

Title: Re: VBA equivalent for VB's App.Instance
Post by: David Hall on December 13, 2006, 12:08:10 PM

I couldn't find anything in VBA or Google

Title: Re: VBA equivalent for VB's App.Instance
Post by: Guest 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.

Title: Re: VBA equivalent for VB's App.Instance
Post by: Chuck Gabriel on December 13, 2006, 12:17:35 PM

What exactly are you up to?

Title: Re: VBA equivalent for VB's App.Instance
Post by: Guest 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.

Title: Re: VBA equivalent for VB's App.Instance
Post by: Chuck Gabriel 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.