Hello!
I need to execute a SQL.REQUEST function in a macro, rather than from a cell. Here is what it looks like in the cell:
=SQL.REQUEST('ACCOUNT LOOKUP'!$D$1,'ACCOUNT LIST'!A1,2,'ACCOUNT LOOKUP'!$B$1:$B$18,TRUE)
using the sytax: (connection_string,output_ref,driver_prompt,query_text,col_names_logical)
so, everything is good to go, just need to know how to trigger it in a macro.
thanks.
I need to execute a SQL.REQUEST function in a macro, rather than from a cell. Here is what it looks like in the cell:
=SQL.REQUEST('ACCOUNT LOOKUP'!$D$1,'ACCOUNT LIST'!A1,2,'ACCOUNT LOOKUP'!$B$1:$B$18,TRUE)
using the sytax: (connection_string,output_ref,driver_prompt,query_text,col_names_logical)
so, everything is good to go, just need to know how to trigger it in a macro.
thanks.