Write in Excel

[venkatbatchu]

Hi Anu,

You dont need to create any objects like xlApp, xlBook,xlSheet.

Code:

Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.WorkBooks.Open("C:\Test.xlsx")
Set xlSheet = xlBook.WorkSheets("Sheet1")

Just delete all the objects related.


Just execute it a i provided and debug this.


Please let me know for further clarification.

Regards,
Venkat.Batchu