VBA Compile Error: expected =

Question

I get an error for my code:

compile error: Expected: =

DoCmd.OutputTo (acOutputReport, _
    ReportName & " " & Load, _
    acFormatPDF, _
    "\\drive\Reports\" & ReportName & " " & Load & " " & Year(Date) & Month(Date) & Day(Date)& ".pdf")

I have Access front-end and SQL-Server backend.

What do I need to do to fix this? I am still a beginner with VBA.

Olivier Jacot-Descombes · Accepted Answer · 2019-06-06 14:57:12Z

3

You must call Sub procedures without parameter parentheses ( ) in VBA.

DoCmd.OutputTo acOutputReport, _
    ReportName & " " & MyLoad, _
    acFormatPDF, _
    "\\drive\Reports\" & ReportName & " " & MyLoad & " " & _
        Year(Date) & Month(Date) & Day(Date) & ".pdf"

Also Load is a reserved word in VBA. It is Sub Load(Object As Object). Use another identifier.

The compile error "Expected: =" may seem awkward, but it makes sense, since parentheses are used for Function calls. I.e., VBA is expecting something like this

x = MyFunc(...)

edited Jun 6, 2019 at 14:57

answered Sep 22, 2015 at 19:46

Olivier Jacot-Descombes

114k14 gold badges149 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

VBA Compile Error: expected =

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related