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.
Code
Sub OpenTxtFile()
Dim TextFileName As String
PathSep = Application.PathSeparator
TextFileName = ActiveWorkbook.Path & PathSep & "zReports" & PathSep & "ExportedData.txt"
Workbooks.OpenText FileName:=TextFileName _
, Origin:=xlMacintosh, StartRow:=1, DataType:=xlDelimited, TextQualifier _
:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, Semicolon:= _
False, Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(Array _
(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8 _
, 1), Array(9, 1), Array(10, 1), Array(11, 1), Array(12, 1), Array(13, 1))
'rest of the code copies the data into a workbook
End Sub
Display More
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.
Thanks