trying to use EVAL correctly

D

dp

Hi everyone,

I could use some help trying to make a variable expression using eval:

Function GetQbTable(sTable As String, sCoreObj As String, oObject As
Variant, sFilterType As String)


Eval ("gConn.Company." & sCoreObj & "." & sFilterType)
' this line should evaluate to
' gConn.Company.CustomerMessages.GetAll


I keep on getting a strange error:

Office cannot find the name "GConn" in the expression you entered
error number 2482.

Looked it up on google, but didn't find any thing really


thanks for any assisance
 
Top