Regarding the 2nd workbook, the VBA code is in one Excel file which creates the other. At this point I'm just simulating both being opened. What I do thereafter is not relevant to my current test.
I did step through the code and the ReadOnly=False in the with statement is where the failure is located. I tried putting it before the Workbook.Open statement and get the same error.
The macro is in a general module in Excel.
I also tried putting the ReadOnly argument (False) in the format below and that produced the same error. Not sure where to go from here.
Code:
With MyXL2
.Application.Visible = True
.Workbooks.Open CurrentProject.Path & "\" & "San Juaquin.xls ", , False
End With