My scenario is i have one sql which fetches result as count. i need to run this sql multiple time but with different columns. So i have input excel file which has all column names and i am passing this excel as input to sql using varaible with for loop.
when i run this process system is sucessfully executing my slq with different columsn and displaying a message box for each run.
Now i need to store output of this edit sql in excel (Note: Output of edit sql is Datatable)
ri used write range but system is storing in only one particuler cell and deletiing and storing in same cell but i need to iterate this and need output in each cell.
can anyone help me with any logic