passing parameter to a ms query

  • Thread starter Thread starter redf1re
  • Start date Start date
R

redf1re

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?
 
thanx... but my problem is that i need the value not by typing o
getting it from a cell.. i need to pass that value as i open excel ..
understand what i mean? i need to pass the value outsite excel to th
inside,
my user wont type it inside excel but outsite, in that remote program

well.... just to make clear im using a ERP from oracle called JDE (o
One World), and im trying to pass this information from the jde t
excel ..
 
lets make it easier...
how can i call excel from dos writing something on a cell ?? that would
do

something like c://excel.exe c://teste.xls "bla bla bla " in H9
 
Explained how it is, only by writing an app that can open the workbook and
pass the variable between the two. Certainly there is now way to pass a
value into a cell via dos in Excel/VBA

Have you considered doing it the other way? Extracting the data *into* the
cell *from* the Excel workbook using ODBC/OLE DB/ADO?

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