Hi,
I need to do function or sub, which is able to edit a SELECT in MS QUERY.
For example:

MS QUERY SQL:
select * from dba.company where name='ABC'

EXCEL VB:
function do_sql(X)
select * from dba.company where name=X
end function

What is the right way to do this. Is it possible to use SQL in VB?

Thanx, kamil