Reading a CELL without using Name Range | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Reading a CELL without using Name Range

Is there any way of reading the contain of a given cell from DTS. I can’t create a Name range as I don’t have control over the Excel
Don’t know what it’s like in DTS. Maybe you’ll find something on
But have a look at the Excel object model for Range (Enumeration (I believe it must be translated so, or Array()) in the online help. You don’t need names.

Frank Kalis
Microsoft SQL Server MVP
Ich unterstütze PASS Deutschland e.V.

I searched at sqldts but couldn’t find any.
I will look for Excel object model
Not sure whether this may help you Madhivanan Failing to plan is Planning to fail
This is seems to be good. But how can I edit the Globle variables