Writing to Run time data table

[Neetha]

Thanks for the quick reply Aditi. I tried to implement your code.

1. The spreadsheet is visible with this line of code you mentioned.

Code:

xl.Application.Visible = true

But, how to keep the cursor focus on the row that the application is currently working on. Can you please provide the code for it?

2. I am able to write the data on to the spreadsheet with the help of your code

Code:

sheet.cells(k,h).value =b

But, I am getting error message when I try to write on run time data table.
Error was saying "The set DataTable.Value operation failed. The <D> column does not exist.

Code:

"DataTable.Value("D", dtGlobalSheet) = a .

Can you please help me out?