StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Here's the <code>OpenText</code> method from Excel 2000:</p> <blockquote> <p><strong>OpenText Method</strong></p> <p>Loads and parses a text file as a new workbook with a single sheet that contains the parsed text-file data.</p> <p><strong>Syntax</strong></p> <p><em>expression</em>.OpenText(<em>Filename, Origin, StartRow, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, DecimalSeparator, ThousandsSeparator</em>)</p> <p><a href="http://msdn.microsoft.com/en-gb/library/aa273712(office.10).aspx" rel="nofollow noreferrer">source</a></p> </blockquote> <p>and here's the Excel 2003 version:</p> <blockquote> <p><strong>OpenText Method [Excel 2003 VBA Language Reference]</strong></p> <p>Loads and parses a text file as a new workbook with a single sheet that contains the parsed text-file data.</p> <p><em>expression</em>.OpenText(<em>FileName, Origin, StartRow, DataType, TextQualifier, ConsecutiveDelimiter, Tab, Semicolon, Comma, Space, Other, OtherChar, FieldInfo, TextVisualLayout, DecimalSeparator, ThousandsSeparator, TrailingMinusNumbers, Local</em>)</p> <p><a href="http://msdn.microsoft.com/en-gb/library/aa195814(office.11).aspx" rel="nofollow noreferrer">source</a></p> </blockquote> <p>so <code>Local</code> was indeed a new parameter for Excel 2003 and won't work in Excel 2000</p> <p>No idea as to the cause of the erroneous behaviour. The <code>Local</code> parameter is defined as:</p> <blockquote> <p><strong><em>Local</em></strong> Optional <strong>Variant</strong>. Specify <strong>True</strong> if regional settings of the machine should be used for separators, numbers and data formatting.</p> </blockquote> <p>You might want to double-check the regional settings on the Excel 2000 PC and check to see if there is anything which may cause the data to be wrongly interpreted. Also, try explicitly specifying the <code>DecimalSeparator</code> and <code>ThousandsSeparator</code> parameters on the Excel 2000 method and see if that helps</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload