Skip to content

Instantly share code, notes, and snippets.

@agbishara

agbishara/VBA - Create new workbook at path

Created April 15, 2014 16:02
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save agbishara/10743965 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save agbishara/10743965 to your computer and use it in GitHub Desktop.
Download ZIP
Function to Create a new workbook in Excell
Raw
VBA - Create new workbook at path
Function CreateWorkbook(Path As String) As Workbook
Dim Tempbook As Workbook
Set Tempbook = Workbooks.Add(ThisWorkbook.Path & "\template.xlsx")
Application.DisplayAlerts = False
Tempbook.SaveAs Filename:=Path
Application.DisplayAlerts = True
Set CreateWorkbook = Tempbook
End Function
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment