ODC named range question
 

Hi all,

Is it possible for me to set up an Office data connection so that i can call
a stored procedure (parameters and all) to populate a named range Excel. I
want to be able to change the SQL string calling the stored proc via code
(change parameters etc), which i think i should be able to do.

The main thing first of all is to see if i can copy to a named range whose
dimensions will change depending on the data returned.

Thanks in advance,

G