Workbooks.Open doesn’t work in Excel 2016

The following code works in older versions of Excel, but in Excel 2016 it fails.  No error message… it just doesn’t do anything.  It will work if I specify a file other than the currently open file, but it doesn’t work the way I intend (which is to open the same file, overwriting any changes without saving in between):

<Code>Sub ReOpenNoSave()

    Workbooks.Open ActiveWorkbook.Path & “” & ActiveWorkbook.Name

End Sub</Code>

Any ideas?

By: Nathan

One thought on “Workbooks.Open doesn’t work in Excel 2016

Leave a Reply

Your email address will not be published. Required fields are marked *