LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
SF SF is offline
external usenet poster
 
Posts: 8
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
fail to link a pdf file in excel 2003 with Adobe Acrobat 7.0 Prof eva cheng Excel Discussion (Misc queries) 0 December 2nd 09 07:40 AM
Excel 2003 hyperlinks to Adobe files fail to open NC Excel Discussion (Misc queries) 0 May 8th 08 03:55 PM
Open and Save fail after SP1 Meltivore Setting up and Configuration of Excel 0 December 18th 07 11:43 PM
Templates fail to open Terry Excel Discussion (Misc queries) 2 February 27th 07 02:57 PM
Templates fail to open Geroge Setting up and Configuration of Excel 0 February 12th 07 02:58 AM


All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"