ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invalid characters in Excel (https://www.excelbanter.com/excel-programming/284028-invalid-characters-excel.html)

Andy

Invalid characters in Excel
 
Hi all,

How can I stop Word, and I assume Excel, auto-converting ... into the
special ... single character (Ascii 133)? Or alternatively, is there any
way I can prevent Excel from accepting characters that visual basic can't
handle? At the moment we export to a psv file and the special character
causes the code that reads it to fail.

Thanks in advance.

Andy



Tom Ogilvy

Invalid characters in Excel
 
Never heard of this in Excel. Perhaps a bad assumption. What characters
get converted?

--
Regards,
Tom Ogilvy

"Andy" wrote in message
...
Hi all,

How can I stop Word, and I assume Excel, auto-converting ... into the
special ... single character (Ascii 133)? Or alternatively, is there any
way I can prevent Excel from accepting characters that visual basic can't
handle? At the moment we export to a psv file and the special character
causes the code that reads it to fail.

Thanks in advance.

Andy





jaf

Invalid characters in Excel
 
Toolsautocorrect. Delete ... (period, period, period,) from the list.


--

John

johnf202 at hotmail dot com


"Andy" wrote in message
...
Hi all,

How can I stop Word, and I assume Excel, auto-converting ... into the
special ... single character (Ascii 133)? Or alternatively, is there any
way I can prevent Excel from accepting characters that visual basic can't
handle? At the moment we export to a psv file and the special character
causes the code that reads it to fail.

Thanks in advance.

Andy





Andy

Invalid characters in Excel
 
Yep, that's it! Many thanks.

Andy



"jaf" wrote in message
...
Toolsautocorrect. Delete ... (period, period, period,) from the list.


--

John

johnf202 at hotmail dot com


"Andy" wrote in message
...
Hi all,

How can I stop Word, and I assume Excel, auto-converting ... into the
special ... single character (Ascii 133)? Or alternatively, is there

any
way I can prevent Excel from accepting characters that visual basic

can't
handle? At the moment we export to a psv file and the special character
causes the code that reads it to fail.

Thanks in advance.

Andy








All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com