Saving UTF-8

[efratnakash]

Is there a way in VBAscript to CreateTextFile in UTF-8, or convert a file to UTF-8?
I am using Excel 2010

[JBeaucaire]

Maybe something along the lines of:

Please Login or Register  to view this content.

[JBeaucaire]

A Google search led to posts that implied saving your workbook in CSV format will suffice as well.

Excel CSV files are normally fine in any situation where UTF-8 encoding is needed - I've never encountered a problem (knock on wood).

[JBeaucaire]

A macro said to accomplish the same task:
http://josephtbradley.wordpress.com/...th-no-orphans/

[efratnakash]

@JBeaucaire: thank you for all your replies, and the link.

I am trying to figure out how to implement it.

Currently I create and open a file, and write line after line (from the sheet data). The name of the output file is sitemap.xml.

I was hoping I could elegantly create a UTF-8 file (means write down the file in UTF-8, as you hinted in your first replies).

Using the function in the link you provided, I understand I should convert the created Unicode file to UTF-8.

If it is not too much to ask, would you please be so kind and update the procedure so it will take full-path-sitemap.xml as an input file, convert and overwrite it as UTF-8?

Many thanks

[efratnakash]

I think I figured out how to implement the code, but get a Compile error: Object required

The fsT= is highlighted in the second line:

Please Login or Register  to view this content.

What might be wrong?

[shg]

Please Login or Register  to view this content.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

[JBeaucaire]

You don't "set" strings. The fsT variable is DIM'd incorrectly. Take off the "As String" after it...probably should be an object.

(EDIT: hat-tip to shg, that's the ticket)

[efratnakash]

For:

Please Login or Register  to view this content.

I get the following error message: Run-time error ‘424’: Object required

Same error when I remove "As String" and stay with

Please Login or Register  to view this content.

[shg]

This writes a string to a UTF-8 file.

Please Login or Register  to view this content.

[efratnakash]

It worked!

Thank you sssoooo much!