'Trying to copy worksheets in multiple pdfs - Syntax Error

Could you kindly help me with this code? I am a beginner..


Sub ExportSheetstoPDF()

Dim ws As Worksheet
Dim mywsname As String

For Each ws In Worksheets
    ws.Select
    mywsname = ws.Name
    Activesheet.ExportAsFixedFormat Type:=xlTypePDF, _
    filename:="Z:\Incent_2022\ORDINARIA\RETAIL-WHS\Schede Obiettivi\Q1\" & "Schede Obiettivi Retail Classico Q1 22_" & mywsname & “.pdf”, _

    Next ws
End Sub

Solution 1:^[1]

Your problem is that the line

Activesheet.ExportAsFixedFormat Type:=xlTypePDF, _
    filename:="Z:\Incent_2022\ORDINARIA\RETAIL-WHS\Schede Obiettivi\Q1\" & "Schede Obiettivi Retail Classico Q1 22_" & mywsname & “.pdf”, _

has the continuation character _ at the end of it, but nothing continues on the next line.

Remove the ,_ from the end of the line

Also the “.pdf” needs to be ".pdf" i.e. using ordinary double-quotes and not ones copied out of an Office document ("intelligent" double-quotes)

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	CHill60

'Trying to copy worksheets in multiple pdfs - Syntax Error

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]