Excel 2007 import text file VBA code - Origin:=

  • Thread starter Thread starter NLC
  • Start date Start date
N

NLC

In the code for text file importing Origin:= seems to always be 437 but I
haven't been able to locate a source for what that code means or what other
code options might exist.
 
Hi,
Tried help?
Origin: Optional Variant. Specifies the origin of the text file. Can be one of the following XlPlatform constants: xlMacintosh,
xlWindows, or xlMSDOS. Additionally, this could be an integer representing the code page number of the desired code page. For
example, "1256" would specify that the encoding of the source text file is Arabic (Windows). If this argument is omitted, the method
uses the current setting of the File Origin option in the Text Import Wizard.

Tried google?
437 is the code page.
http://en.wikipedia.org/wiki/Code_page_437


John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Utility to flatten/import X12 834 file into Excel 3
Conversion from text to excel 2
Date formatting in VBA 1
Macro that will insert a simple text string in top cell of text file 1
Importing text file into Excel 2003 - C# - QueryTables.Add throwsSystem.ArgumentException 0
Text Importer 2
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0

Back
Top