In the MSDN link the following is stated:
If the file is a text file, this argument indicates where it originated, so that code pages and Carriage Return/Line Feed (CR/LF) can be mapped correctly. Can be one of the following XlPlatform constants: xlMacintosh, xlWindows, or xlMSDOS. If this argument is omitted, the current operating system is used.
When I try to open a text file that originated in a Windows PC but I use the enumeration value 1, that is Macintosh (see enum values) it opens correctly. Should this be the case given that a wrong origin has been mentioned? I understand that this is an optional parameter but i would like to understand when to use this parameter...can someone pls help?The command used was:
oxl.Workbooks.Open("G:\Excel Experiments\mytestData.txt",,, ,,,, 1)