Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
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
Export CSV dash is \226 (unicode) wjr New Users to Excel 3 November 14th 09 01:32 AM
How to get Excel to correctly display imported UTF8-encoded data ? Elizabeth Excel Worksheet Functions 0 April 24th 08 03:01 PM
Opening UTF8-encoded CSV file (Excel 2004 for Mac) Antonio[_2_] Excel Discussion (Misc queries) 2 October 30th 07 10:30 PM
How can I transfer a Utf8 file from word to excel? Shawn Excel Discussion (Misc queries) 0 May 20th 05 02:57 PM
Saving sheet as a UTF8 file dejudicibus Excel Programming 0 November 16th 03 01:26 AM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"