VBA to automatically run another macro after report is ran

[steve400243]

Hello, thanks for any help that can be provided.

I use this msgbox code to run macro"t" when a user opens the workbook. After this is complete, I want another macro to run automatically without the select button.

Private Sub Workbook_Open()
    If MsgBox("Hello, Would you like to Create a new report?", vbYesNo, "CFS DATA ANALYSIS REPORT") = vbYes Then Call t
End Sub

the other macro to autorun is "getuniques" and is in module2

Sub getuniques()
   Dim d As Object, c As Variant, i As Long, lr As Long
   Set d = CreateObject("Scripting.Dictionary")
   lr = Cells(Rows.Count, 1).End(xlUp).Row
   c = Sheets("Sheet1").Range("A2:A500" & lr).Value2
   For i = 1 To UBound(c, 1)
     If c(i, 1) <> "" Then d(c(i, 1)) = Empty
   Next i
   Sheets("ANALYSIS").Range("U3").Resize(d.Count) = Application.Transpose(d.Keys)
End Sub

 

[Norie]

Try this.

Private Sub Workbook_Open()
    If MsgBox("Hello, Would you like to Create a new report?", vbYesNo, "CFS DATA ANALYSIS REPORT") = vbYes Then 
        Call t
        Call getuniques
    End If
End Sub

 

[steve400243]

Norie, Thank you! that works as needed. I tried different combinations of this and could not get it to work. Much appreciated.