I want to automate a report generation ,and where i struggle is like i want to send the data in same excel sheet across 5 different tabs ,currently i could just send data to 5 different excel sheet only .
Can anyone suggest on this ,is that possible to convert data into same excel sheet across tabs using IEBGENER or any other utilities ?
Also is there any way to make the excel sheet as password protected

Thanks in advance