Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving sheet as a UTF8 file
Hi. I am a user of Excel but I have no Visual Basic know-how. I need to develop a macro that cannot be obtained by simple recording. I have a two columns Excel sheet. I need to save it as a Unicode UTF8 file where each cell of the first column is suffixed by a string separator (say XXX) and each cell of the second column is suffixed by another string separator (say YYY). So, if my sheet is Aaaaaa | Bbbbbb Cccccc | Dddddd Eeeeee | Ffffff the resulting binary file will be AaaaaaXXXBbbbbbYYYCcccccXXX... and so forth. It is probably a very simple macro for a n Excel programmer, but I have no idea how to do it. Any help appreciated. DdJ ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening UTF8-encoded CSV file (Excel 2004 for Mac) | Excel Discussion (Misc queries) | |||
Saving a sheet as a separate file | Excel Discussion (Misc queries) | |||
Saving sheet to text file | Excel Discussion (Misc queries) | |||
How can I transfer a Utf8 file from word to excel? | Excel Discussion (Misc queries) | |||
Is it possible to recover a deleted sheet after saving the file? | Excel Discussion (Misc queries) |