Select and switch calender dates in Search Console connector with macro

#1

Hi
I'm trying to automate my search console workflow and fail on this.
The workflow looks like:

  1. set date

  2. click "Insert" to get data

  3. open new tab

  4. set another date

  5. same steps...
    I tried to record a macro on doing these steps manually, but got a macro code, which doesn't reproduce my steps. This is the macro code i got:

    Sub Makro1()
    '
    ' Makro1 Makro
    '
    ' Selection.ClearComments
    Sheets.Add After:=ActiveSheet
    Selection.ClearComments
    End Sub
    Nothing.
    Does somebody got such task done? Please share your thoughts an hints! Thanks

#2

In the meanwhile my Macro works:
it looks like

Sub MyMacro()
 Dim i As Integer, myname As String
  myname = ThisWorkbook.Name
   For i = 1 To 90
  Windows(myname).Activate
  Range("A" & i).Select
   Selection.Copy
   Workbooks.Add
   ActiveSheet.Paste
   Application.CutCopyMode = False
   Calculate
   ActiveSheet.Calculate
   ActiveWorkbook.SaveAs Filename:= _
    "Z:\file" & i & ".csv", FileFormat:=xlCSV, _
    CreateBackup:=False
   ActiveWorkbook.Close True 
   Next i
 End Sub

The macro gets formulas from the worksheets column - formuals look like

  =Dump(Connector("GoogleSearchConsole.SearchAnalytics";"https://www.example.com/";"2016-06-01";"2016-06-01";"";"web";5000;"date,query,page,clicks,impressions,ctr,position";WAHR))

The problem is - formulas aren't calculated in the saved files - don't know why. AddIn is activated and login into the search console is done before running macro.
Could somebody point me into the right direction, so