Excel 2010 - choose codepage when saving as text?

[Greg Lovern]

For those of you using the Excel 2010 beta -- when saving as text,
does it allow choosing the target codepage, as Word allows?

For example, if I'm running English Windows, can I save a text file
from Excel as "Japanese (Shift-JIS)" encoding?

Or does it still only save as the currently active Windows codepage?


If my question is not clear:

in Word, if you save as "Plain Text (*.txt)", you get a "File
Conversion" dialog, which allows you to select the "Other encoding"
radio button, then choose from a long list of codepages in a listbox.

Word has had this feature at least since 2003, not sure offhand about
earlier. Just wondering if we'll have it in Excel 2010.

What we're doing now is automating Word from Excel to open the text
file we save from Excel, then save it as Shift-JIS. But besides taking
more time, it requires Word. It would be nice to be able to do it
directly from Excel.



Thanks,

Greg

 

[Homey]

i have technical preview not beta. beta come out this month they say.
anyway i see nothing different in saving to text format. no code page
selcting.


| For those of you using the Excel 2010 beta -- when saving as text,
| does it allow choosing the target codepage, as Word allows?
|
| For example, if I'm running English Windows, can I save a text file
| from Excel as "Japanese (Shift-JIS)" encoding?
|
| Or does it still only save as the currently active Windows codepage?
|
|
| If my question is not clear:
|
| in Word, if you save as "Plain Text (*.txt)", you get a "File
| Conversion" dialog, which allows you to select the "Other encoding"
| radio button, then choose from a long list of codepages in a listbox.
|
| Word has had this feature at least since 2003, not sure offhand about
| earlier. Just wondering if we'll have it in Excel 2010.
|
| What we're doing now is automating Word from Excel to open the text
| file we save from Excel, then save it as Shift-JIS. But besides taking
| more time, it requires Word. It would be nice to be able to do it
| directly from Excel.
|
|
|
| Thanks,
|
| Greg