View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sergei Sergei is offline
external usenet poster
 
Posts: 6
Default Programming MS Query

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