Thread: Replace string
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Geoff Geoff is offline
external usenet poster
 
Posts: 371
Default Replace string

kycode is a construct from the wbook name so I could add the apostrophe
though it is ironic that prior to this I have spent a lot of effort deleting
unwanted characters from the imported data I am processing <g

But it does work and it's woth going for. Thanks for that. I'm still
curious though as to why the string requires it.

Geoff

"Gary''s Student" wrote:

Instead of:
kycode="01"
use:
kycode="'01"
--
Gary''s Student - gsnu200787