why error if available methods are used.

[AAB]

Hi,
Though a lot of code is available for working with excel still want to clear a confusion as follows:

Code:

Set obj=Createobject("Excel.application")
obj.visible=True

Now when i use the following code:
obj.worksheets.add or
obj.worksheets(1).add

It shows "Unknown runtime error"

Not able to understand why is it so.Can anybody clarify this?

[manabh]

Hi,
Set obj=Createobject("Excel.application")
After this statement, check

Code:

If obj = nothing then
    read error!
end if

[ravi.gajul]

Please correct your code

Code:

Set obj=Createobject("Excel.application")
obj.visible=True
Obj.WorkBooks.add

[AAB]

Thanks for your reply.
Actually the confusion i had was why it showed error on placing worksheets in place of workbooks in the above code.
But now i have found that it shows error as it does not know in which workbook it should add the worksheet.