Excel 2010 VBA - SaveCopyAs error 9 Subscript out of Range

[rjhanson]

Hello all,

I am trying to copy an open workbook used by someone else. The SaveCopyAS is suppose to do this per Excel, but I am getting error 9, Subscript out of Range. Here is my very simple script

Sub Create_Read_Only_Copy_Of_Workbook()

Workbooks("Internal Master Schedule FY14.xlsx").SaveCopyAs "Internal Master Schedule FY14 - Read Only.xlsx"

End Sub

I have tried it with full paths and without as you see above, both give error 9

Anyone seen this or can see what I am doing or not doing?

Thanks

Richard

[shg]

The workbook must be open in that instance of Excel, and the name must be exactly correct, other than case.