Newsgroup problems...

[Mike Mertes]

When I posted earlier, my post appeared for a split second, then disapeared
and never came back.

Why does this happen, and how can I prevent it from happening in the future?

 

[Doug Glancy]

Mike,

I see a post from you at 11:22 with the title "Bugesque..." I use Outlook
Express 6 and subscribe directly through msnews.microsoft.com (not my isp)
and never have problems.

hth,

Doug Glancy

 

[Mike Mertes]

That is sincerely odd. I connect the same way but the message is not in my
list. To double check I even organized posts by author's name.

I will play with some synchronization settings and see if it updates
correctly afterward.

And BTW, that "Bugesque," post is the one that appeared for a moment, then
disapeared.

 

[JulieD]

Hi Mike

the same thing happened to me yesterday ... i wrote a reply to a post ... it
appeared for a minute and then said that the post had been removed off the
server and then the it completely disappeared! (and i didn't even say
anything nasty ... however i can see your last post too - with a reply
from Dick Kusleika .. do you see his reply, if not, would you like me to
email it to you.

Cheers
JulieD

 

[Mike Mertes]

Even though I received a response I still can't read it! If you or
someone else could repost it here I would appreciate it

Thanks!

 

[JulieD]

here's a copy of the whole post from Dick Kusleika

Mike

I read your later message, so I hope you can read this.

Firstly, when I call Workbooks.Open "#8321-2.xls", Excel opens the correct
workbook but appends a number onto the end of it's name. The first time that
line of code is executed I end up with an open workbook named,
"#8321-21.xls." After I close it and execute that line again, the result is,
"#8321-22.xls." And the third time, "#8321-23.xls" And so on, and so on.

I am absolutely positive that the correct file name is "#8321-2.xls." When I
open the file manually Excel DOES NOT append arbitrary numbers to the file
name. Also, this same bit of code successfully opened about 400 workbooks
previous to this one, but the error ONLY occurs on this particular file
name.

Is this an Excel bug or what?!

When you open a template, Excel makes a unique name by appending an integer
to the end. It sounds like you're using Workbooks.Add instead of
Workbooks.Open.

Secondly, in this same project there is a line of code that's something like
this, "FileSystemObject.MoveFile SourcePath\FILENAME~1.xls, DESTINATION."
This worked successfully until it encountered a file name with a tilde in
it. It appears that VBA interprets the tilde, "~," as a wildcard character
even though it's in a string. Literally: fs.Movefile "MyFile~1.xls"

How is this possible? And, is there a way to disable it, or change the wild
card character? I think it would be pretty ridiculous to set up a wildcard
character that naturally occurs in file names... But, it really looks like
that's what's happening.

The tilde is a "negate wildcard" character. When you do an Edit > Find in
Excel, for example, and you want to find an asterisks (a wildcard
character), you precede it with a tilde. Since MoveFile allows you to use
wildcards, the tilde is part of the package. Use two tildes (~~) to mean a
literal tilde.

See also http://www.dicks-blog.com/excel/2004/05/finding_wildcar.html