>Does someone knows how to open programatically Microsoft Query in Excel ?
>In Excel from the Data menu, choose Get External Data. Microsoft Query opens.
>
>A customer want to open Query window opens automatic from VFP so the enduser doesnt has to know about the stuff to connect to the server.
>
>I recorded a macro but when I was looking the code, nothing about Microsft Query was there.
>
>Thanks in Advance.
>
Peter,
MS Query is designed to return result sets to Excel. Maybe you could VFP's DDE commands to work with it and do the same thing, I don't know. The MS Query Help gives all the DDE commands supported by it and some examples on how to use them.
However, if you simply want an ad hoc query interface for your users, maybe one of the entries in the Downloads section will help. Use "query" in the Description field.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao