the reason is that Microsoft doesn't offer free support. You can contact
microsoft and open a support incident and pay for support. If it turns out
that the cause is a bug in the product, then you will not have to pay.
the reaons you probably aren't getting support is that the cause is more
than likely something to do with your code construction and not a known flaw
in excel.
for instance, this statement seems problematic:
In the middle of the Excel portion of the VBA (the calling Access file has
been closed)
If the code is in Access, then if you close the file, it seems natural the
code would halt. - but you said it worked in earlier versions, so if
absolutely no changes have been made, it isn't obvious what would cause this,
but support for automation has not changed in Office XP. Also, I suspect
that even Microsoft would be hesitant to try to debug a user built
application that automates between two products just because of the
complexity (unless you describe a known situation - not all of these are
documented in the knowledge base).
Also, you have described your code a halting (which is one type of problem).
Yet later you refer to an error message, but never say what the error
message is. Experiencing an error is a much differnt situation than code
halting with no indication of why.
--
Regards,
Tom Ogilvy
"BAC" wrote:
I have a problem that does not seem to be attracting an answer in the group
discussions from MVP's or others.
Why can't there be a "refer question to Microsoft" option/button somewhere
for when this happens? Or an option to refer to a specific MVP who may have
more contacts and knowledge of individuals who may have an answer?
See discussion "VBA Code stops randomly" and note that the 1st time I
submitted this questin i got no replies, but now I'm mostly getting others
who have the same proble, but no suggestion as to cause or fix!
thanx
BAC
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...el.programming