Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fail to open unicode txt file in excel
Hi,
I can mannually import a unicode text file into excel by specifying the File origin to be "65001 : Unicode (UTF-8)" but fail to automate the opening of the same file with the following code. Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Set xlApp = CreateObject("Excel.Application") xlApp.Visible = True xlApp.Workbooks.OpenText "C:\PIC\OUTPUT.TXT" = Excel open the OUTPUT.TXT file but not display the correct Unicode format Could someone advice SF |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fail to link a pdf file in excel 2003 with Adobe Acrobat 7.0 Prof | Excel Discussion (Misc queries) | |||
Excel 2003 hyperlinks to Adobe files fail to open | Excel Discussion (Misc queries) | |||
Open and Save fail after SP1 | Setting up and Configuration of Excel | |||
Templates fail to open | Excel Discussion (Misc queries) | |||
Templates fail to open | Setting up and Configuration of Excel |