Open a specific text file with Excel 2019 for Mac

  • Excel 2019 for Mac no longer supports "Workbooks.OpenText Filename". I've Googled the issue, and all of the posts I've found are for "GetOpenFilename" which doesn't get me where I want to be. My current code opens a specific file in a specific location.

    This code works fine in Excel 2011 for Mac, but does not work in Excel 2109 for Mac.

    I need help with code that will work in Excel 2019 for Mac.