Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 44
Default from XLS - notepad: incomplete text & UTF-8

hello,

i have such a code in VBA:

Dim FF As Integer
Dim fileHTML As String
Dim tekst As String
Dim rng As Range

fileHTML = Sheets("import").Range("D8").Value
FF = FreeFile
Open fileHTML For Output As #FF
For Each rng In Sheets("export").Range("H4:H16358")
tekst = rng.text
Print #FF, tekst
Next
Close #FF

short explanation:
there is HTML code in range: H4:H16358, in which i've declared UTF-8,
and same values in several cells from this range are longer than 512 (or 1024 digits)
what cause 2 problems:

1. default notepad charset is ANSII. how can i change it into UTF-8?

2. values longer than 512 (or 1024) digits are cut, what cause lack in html code

rgs
pm
Reply
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
How can I copy plain text from Excel to Notepad? ymgagnon Excel Discussion (Misc queries) 5 October 1st 09 09:26 PM
Incomplete text wrap within a single cell Ken Excel Discussion (Misc queries) 1 December 9th 08 11:34 PM
Formula incomplete Wanna Learn Excel Discussion (Misc queries) 2 September 25th 08 01:01 PM
Sorting is Incomplete Patlee Excel Discussion (Misc queries) 13 May 26th 07 07:30 PM
Getting Notepad.exe text in Excel including leading spaces Sally[_5_] Excel Programming 1 November 3rd 05 10:12 PM


All times are GMT +1. The time now is 03:35 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"