Close Workbook VBA

[Brightspark98]

Hi,

I have a workbook that stores a Macro that saves the current worksheet in another workbook as a PDF.

The Macro is activated using button in the quick access toolbar.

I cant get the workbook that holds the macro to close after the PDF has been created.

The workbook that holds the macro is called SaveMacro.xlsm

Any help would be greatly appreciated.

Sub PDFActiveSheet()


Dim wsA As Worksheet
Dim wbA As Workbook
Dim strTime As String
Dim strName As String
Dim strPath As String
Dim strFile As String
Dim strPathFile As String
Dim myFile As Variant
On Error GoTo errHandler


Set wbA = ActiveWorkbook
Set wsA = ActiveSheet
strTime = Format(Now(), "dd_mm_yyyy")


Filename = ActiveWorkbook.Name
If InStr(Filename, ".") > 0 Then
   Filename = Left(Filename, InStr(Filename, ".") - 1)
End If


'get active workbook folder, if saved
'strPath = wbA.Path
If strPath = "" Then
  strPath = "FilePath Goes Here"
End If
strPath = strPath & "\"


'replace spaces and periods in sheet name


strName = Replace(wsA.Name, " ", "")
strName = Replace(strName, ".", "_")


'create default name for savng file
strFile = Filename & "_" & strName & "_" & strTime & ".pdf"
strPathFile = strPath & strFile


'use can enter name and
' select folder for file
myFile = Application.GetSaveAsFilename _
    (InitialFileName:=strPathFile, _
        FileFilter:="PDF Files (*.pdf), *.pdf", _
        Title:="Select Folder and FileName to save")


'export to PDF if a folder was selected
If myFile <> "False" Then
    wsA.ExportAsFixedFormat _
        Type:=xlTypePDF, _
        Filename:=myFile, _
        Quality:=xlQualityStandard, _
        IncludeDocProperties:=True, _
        IgnorePrintAreas:=False, _
        OpenAfterPublish:=False
    'confirmation message with file info
    MsgBox "PDF file has been created"
End If




exitHandler:
   Exit Sub
   
errHandler:


    MsgBox "Could not create PDF file"
    Resume exitHandler
    
    
End Sub

 

[Brightspark98]

Ive tried

Workbooks("SaveMacro.xlsm").Close SaveChanges:=False

But depending upon where I place this code I either get an error message or nothing.

Thanks

 

[Brightspark98]

The error I get is Application defined or object defined error

 

[Brightspark98]

Hi,

I added this line (probably the wrong way to go ) but it now works.

Application.DisplayAlerts = False