any one knows how to set an excel object to instance type....thanks

>how to set an excel object to instance type?

Please try to be more specific. I think you want to create objects/instances of workbook, worksheet. Take a look at this article - http://support.microsoft.com/kb/302094.

Please read member rules and homework policy at daniweb.

thanks,,i worked it out anyway its all to do with com ref library