You can pass parameters to an Excel query very simply either as hard coded
values or from cells or, if a user is present, typed into boxes.

I'm not sure how you will implement this in your scenario, maybe in the
workbook_open() event, but here is a link to my site with the GUI
implementation

http://www.nickhodge.co.uk/gui/datam...taexamples.htm

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"redf1re" wrote in
message ...

hi... im running excel from a remote program and i need to pass a
parameter for a ms query, such as a primary key, ...
the call for the excel is treated like a dos calling: excel.exe
c://file.xls .. and it opens the file.xls.. but it has a ms query
and i need to pass a primary key

ideas?


--
redf1re
------------------------------------------------------------------------
redf1re's Profile:
http://www.excelforum.com/member.php...o&userid=31258
View this thread: http://www.excelforum.com/showthread...hreadid=509317