Weekly report macro

Hi guys, I'm using gcaltoexcel in order to export data from gcal to excel...
Right now I have a pretty basic recorded macro that allows me to put all the data in a selected sheet, but I don't wanna do that, what I really want is everytime I run the macro, I want it to open up a new sheet.
So every week I run the macro and I will have "week 1" "week 2" sheet and so on

ty

This line will add a new sheet to the workbook. There are many different ways that you can assign the name

Please Login or Register  to view this content.