Run VBA When Work Book Opens

[MrMaker]

Hi all,

I've got the below code which works very well, however, I'd like it to automatically run when the workbook is opened.

What do I need to do?

Sub SaveAsPDF()
Dim fName As String
With ActiveSheet
    fName = .Range("A1")
    .ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
            "C:\Users\USERNAME\Desktop\" & fName, Quality:=xlQualityStandard, _
            IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
End With
End Sub

Thanks in advance

 

[Crystalyzer]

Put the below in the "ThisWorkbook" section of the vbe

Private Sub Workbook_Open()
      Call SaveAsPDF
End Sub

 

[MrMaker]

Easy when you know how ?

Thank you very much, I knew it would be a simple one

All the best