N
Norbert Winkler
Hi,
I'm using in Excel 2003 an ODBC-Query to retrieve Data from a Oracle-table.
Now I want to use a parameter like "where key_col = :key_value"
In Access it is possible to write a VBA-function
function giveValue() as Integer
begin
giveValue = 1234
end
and use it in the where similiar like "where key_col = giveValue()"
But this doesn't work in Excel. Is there any other way to set
aparameter-value i.e. in a cell and use it by vba-makro to modify the
query.
I'm using in Excel 2003 an ODBC-Query to retrieve Data from a Oracle-table.
Now I want to use a parameter like "where key_col = :key_value"
In Access it is possible to write a VBA-function
function giveValue() as Integer
begin
giveValue = 1234
end
and use it in the where similiar like "where key_col = giveValue()"
But this doesn't work in Excel. Is there any other way to set
aparameter-value i.e. in a cell and use it by vba-makro to modify the
query.