Saving sheet as a UTF8 file

D

dejudicibus

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert Chinese character to UTF8 for hyperlink 0
Save file 2
forcing specific sheet opening upon launch of .xlsx file 4
HTML string not formatting when copied into sheet 0
Copy range from multiple files in multiple folders to single sheet in master WB 10
Unprotect sheet when Saving As 2
How to show utf8 encoded csv file in excel correctly 0
HOW DO I USE EXCEL TO CREATE FILEs AND FOLDERS FROM A TEMPLATE? 1

Top