Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy plain text from Excel to Notepad? | Excel Discussion (Misc queries) | |||
Incomplete text wrap within a single cell | Excel Discussion (Misc queries) | |||
Formula incomplete | Excel Discussion (Misc queries) | |||
Sorting is Incomplete | Excel Discussion (Misc queries) | |||
Getting Notepad.exe text in Excel including leading spaces | Excel Programming |