No, I believe you are correct that it would require using Excel automation.

Sorry it does not help.


"Abhi Kumar" wrote:


Hi JMB,

I think to use Sheet.UsedRange or Sheet.Object requires that I have to
create an object of something like

Dim sheet as Excel.Worksheet

If this the case then , my point is that I want to avoid all sorts of
Excel Automation

Else
if I have misunderstood u pls elaborate the sulution a little more.

Regards,
Abhi


--
Abhi Kumar
------------------------------------------------------------------------
Abhi Kumar's Profile: http://www.msusenet.com/member.php?userid=5025
View this thread: http://www.msusenet.com/t-1871047471