Auto Execute Excel Macro from Template

[grannyM]

I'm new to writing macros in Excel. In Word if you have a template on the General Tab under File/New, it will automatically execute when you double-click on the icon. How do you get an Excel Macro on a template to excute from the General Tab under File/New? When I double-click on the icon it will only open the template, not execute the macro.

 

[VBslammer]

You need to call the macro from the workbook's Open() event:

'@---------- Workbook Module ------------@

Private Sub Workbook_Open()
  Call GetFileName
End Sub



'@-------------- Module 1 ---------------@

'Macros

Sub GetFileName()
  Dim strTitle As String
  
  strTitle = InputBox("Enter Workbook Name:", "Title", "")
  
  If Len(strTitle) > 0 Then
    ActiveWorkbook.SaveAs strTitle & ".xls"
  End If
End Sub

VBSlammer

Unemployed in Houston, Texas

 

[grannyM]

It worked! It was almost one of those "Duh, I should have known that" questions, so I really appreciate your response. Thank you!