If you shell it you have little chance as that will create an independent
process that you cannot access.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sergei" wrote in message
...
OJ, hi

Sorry I did not make myself clear. I am developing application an Excel
application using VSTO 2005 & VB. NET 2005. Instead of writing a Query
builder I'd like to use MS Query calling as follows

i = Shell("MSQRY32.exe",...)

I have experimentally figured out that I could pass a file name such as
*.dqy or *.dsn, but could not find a way how to pass the results from MS
Query back to my application.

Thanks,

"OJ" wrote:

Hi Sergei,
my first reaction is why not use ADO? My second is how can you return
results from MSQuery without opening MSQuery?

What sort of Database are you querying? What platform/version of Excel?
Do oyu have any code yet tht you can post?

OJ