Workbook.Open VBA Syntax Error expecting "="

Question

The following code shows a syntax error. A compile error expecting an "=". Can't understand what the error is. Please help.

Creating a macro to open multiple password protected workbooks.

    Workbooks.Open(Filename:=myPath & myFile & myExtension, Password:=pw)

A compile error expecting an "=". Can't understand what the error is. Please help.

Remove the brackets `Workbooks.Open Filename:=myPath & myFile & myExtension, Password:=pw` — chris neilsen, Jul 26 '19 at 03:41

score 0 · Accepted Answer · answered Jul 26 '19 at 12:51

0

So we can mark this as answered (Chris Neilsen):

By adjusting the code from: Workbooks.Open(Filename:=myPath & myFile & myExtension, Password:=pw) to Workbooks.Open Filename:=myPath & myFile & myExtension, Password:=pw

The code runs fine now

answered Jul 26 '19 at 12:51

Mark S.

1,474
1
6
20

Workbook.Open VBA Syntax Error expecting "="

1 Answers1