Excel.Application and adding named ranges in workbook

[TomasCrossroads]

Hello,
Im' trying to open an excel workbook and give a named range to the contents of one worksheet. I need that named range to open a recordset afterwards...
Anyone who can help me with some code. I know more or less how to accomplish it in VBA, but in not in ASP Code.

In VBA it looks like this:

ThisWorkbook.Names.Add Name:="NewName", RefersTo:="=$A$1:$C$10"

How to I translate this in ASP Code ??

Any other ideas on how to open an Excel data-source? The only thing that worked succesfully up to now is to query the contents of a named range in excel. It would be easier if I could just query a worksheet, regardless of how it is named or how big it is...

Thanks for any hints.