Windows Server - Location of RetrieveGlobals9.dll

Asked By Merv Rutt on 08-Dec-11 08:47 AM
I am trying to compile a VBA module to customize a GP form.  It doesn't compile because existing code attempts to use RetrieveGlobals9.dll.  I need to add a reference, but I cannot find this class library.  Where is it found and/or how do I get it if not found?


MikeD replied to Merv Rutt on 09-Dec-11 10:59 AM
What version of GP is this for?

If this is GP9, you can download RetrieveGlobals9 from either CustomerSource
or PartnerSource; just do a search for it.

If 10 or later, you do not need RetrieveGlobals anymore.  Instead, simply use
the UserInfoGet object. You do not need to add a reference for this or even
explicitly instantiate it because it is part of the Dynamics VBA library.
Here is an example on opening a ADO Connection:

Private Function OpenConnection() As ADODB.Connection

Dim oConn As ADODB.Connection

Set oConn = UserInfoGet.CreateADOConnection
oConn.CursorLocation = adUseClient
oConn.DefaultDatabase = UserInfoGet.IntercompanyID

Set OpenConnection = oConn

End Function

Mike



.