Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 import text file VBA code - Origin:=
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007 import text file VBA code - Origin:=
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 "NLC" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import text file into Excel 2007 then copy sheet to another workbo | Excel Discussion (Misc queries) | |||
Text File Import - File Origin | Excel Programming | |||
Text Import Wizard: Default File Origin Resolution | Excel Discussion (Misc queries) | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
Text Import Wizard: File Origin Problem | Excel Discussion (Misc queries) |