View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pm[_2_] pm[_2_] is offline
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