Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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




  #3   Report Post  
Posted to microsoft.public.excel.programming
jaf jaf is offline
external usenet poster
 
Posts: 300
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel invalid reference juanita Excel Discussion (Misc queries) 0 September 18th 09 06:09 PM
Invalid web query Excel 2007 Bob Excel Discussion (Misc queries) 0 June 26th 09 03:51 PM
Invalid cell format in Excel MichaelRobert Excel Discussion (Misc queries) 4 November 8th 07 03:08 PM
Formula to replace invalid filename characters tschultz Excel Worksheet Functions 2 January 27th 06 07:07 PM
In Excel find characters when multiple characters exist w/i a cel teacher-deburg Excel Worksheet Functions 1 December 5th 05 10:22 PM


All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"