CDO is the acronym that means that you're using MS web based interface.

And the bad news is that the web based stuff does sometimes add those extra
characters.

I have no idea why it's sometimes and not always.

You may want to switch to a real newsreader (Rick's suggestion).

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsof...ic.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsof...heet.functions
news://msnews.microsoft.com/microsof...excel.newusers
news://msnews.microsoft.com/microsof...el.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsof....docmanagement
news://msnews.microsoft.com/microsof...word.word97vba
news://msnews.microsoft.com/microsof....word.newusers
news://msnews.microsoft.com/microsof...ord.pagelayout
news://msnews.microsoft.com/microsof...ord.vba.addins
news://msnews.microsoft.com/microsof....vba.beginners
news://msnews.microsoft.com/microsof....customization
news://msnews.microsoft.com/microsof...rd.vba.general
news://msnews.microsoft.com/microsof....vba.userforms
news://msnews.microsoft.com/microsof....word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tut...e_ng/index.htm

And if you're looking for old posts:

Or you can use google (maybe a few hours behind) to search for stuff you've
posted (and find the replies, too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_gr...Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm

=============
Sometimes, these newsreaders can't access the newsgroups from behind firewalls
(like at work). If you can't use a newsreader, you may want to switch to
Notepad (instead of MSWord).

There are lots of characters that get mangled when copy|pasting from MSWord into
a plain text message.

Mats Samson wrote:

Hello guys,
I don't understand this! What is CDO? I'm connecting to Office Online from
the link in the email message, i.e. through IE. So Ricks reply to me was read
directly in Office Online. Why would his first message suddenly put an extra
dot after Column-:
With Selection
.End(xlToLeft).Resize(2, .End(xlToRight).Column - ..End(xlToLeft).Column +
1).Copy
End With
but not the second, same "string".
When I write replies I use Word to compose my message and copy the message
to the Office Online New/Reply window. The reason is that Office Online logs
you out if you're idle to long when composing the message (yeah, yeah, I have
to stop and think once and a while) and then all what you've written is gone.
Cheers
Mats

"Rick Rothstein (MVP - VB)" wrote:

I don't think you can do anything except that recommendation to use a
newsreader that doesn't do it.

Okay, thank you. As I said, this was a new one on me... I never had this
occur to me before, so it was somewhat of a surprise.

Rick



--

Dave Peterson