Thread: A macro to export a sheet as UTF8 encoded Unicode file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dario de Judicibus Dario de Judicibus is offline
external usenet poster
  
Posts: 8
Default A macro to export a sheet as UTF8 encoded Unicode file
I need support to create a macro. I have very little skill on VB for Excel.

I have a two columns sheet. I need to export it to a file (selected by user
by save as dialog) with the following format:

0xFFFE
UTF-8(cell(1,1).Value) 0x2028 UTF-8(cell(1.2).Value) 0x2029
UTF-8(cell(2,1).Value) 0x2028 UTF-8(cell(2.2).Value) 0x2029
....
UTF-8(cell(last,1).Value) 0x2028 UTF-8(cell(last.2).Value) 0x2029
0xFFFF

Any help appreciated.

Dario de Judicibus


Reply With QuoteReply With Quote