Is there a way to make a bot add a new Excel sheet daily? What I'm trying to do is have the bot read results from SQL and paste the results into Excel.. but I don't want to have it overwrite the old data as this will run each day. I was thinking it'd be easiest to have it just add a new sheet after it gets the SQL results, but I'm not seeing that command under the Excel options.
The only other thing I can think of is to have it paste under the previous day's results, but I'm not entirely sure how to make it know where the new "Active Cell" should be each day. This is something basic I wrote for a different bot, maybe there's a way to modify it?
