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?

--
-Mike Mertes
Airtron, Tampa Bay

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" wrote in message
...
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?

--
-Mike Mertes
Airtron, Tampa Bay

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.

--
-Mike Mertes
Airtron, Tampa Bay

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" wrote in message
...
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.

--
-Mike Mertes
Airtron, Tampa Bay

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!

--
-Mike Mertes
Airtron, Tampa Bay

"JulieD" wrote in message
...
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

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...g_wildcar.html

--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com