Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am trying to print the value of a cell in Excel to a file "temp.html". The button's macro looks like this: Sub Text() Dim i As Long Open "c:\temp\Homepage.html" For Output As #1 For i = 1 To Selection.Cells.Count Print #1, Selection.Cells(i).Value Next i Close 1 End Sub I need to know what to add to this code so that the file is created as UTF-8 encoding. I am trying to preserve foreign characters, and currently they are all being saved as "???????????". Thanks! -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Creating a macro to print to file | Excel Programming | |||
run macro then print the results as pdf file changing the name eac | Excel Discussion (Misc queries) | |||
Print / Write to text file and usage of buttons | Excel Programming | |||
Print content of cells to a text file | Excel Programming | |||
How to print current data and time to text file | Excel Programming |