System Error &H8001010D (-2147417843) An outgoing call cannot be executed

[PaxMundi]

Hi everybody, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
I've developed an EXCEL-VBA application (originally in MS Office 2007 Professional SP2). It executes smoothly in XP and Vista (MS Office 2007 Professional SP2).<o></o>
The application uses the MSCAL.OCX (calendar control 12.0, which is part of ACCESS 2007). <o></o>
When trying to install the software on another PC (VISTA Office 2007 without Access and without MSCAL.OCX - I had to copy the file and register it via regsvr32.<o></o>
After that, the application runs also on that configuration.<o></o>
<o> </o>
However, the problem arose when I had to install my software on another PC (Windows7 & Office 2010), since Microsoft removed MSCAL.OCX from Office 2010. Microsoft says (and I quote):​

"Calendar control<o></o>

Calendar control (mscal.ocx) was a Microsoft Access feature that could be used in Access worksheets. Calendar control is removed in Access 2010 and is not usable for Excel 2010."<o></o>

<o> </o>

I did manage to install the calendar control 12.0 on that machine, but since then my application encounters the following error every once in a while:<o></o>

<o> </o>

System Error &H8001010D (-2147417843)
An outgoing call cannot be executed because the application is
forwarding an input-synchronized call.<o></o>

<o> </o>

Well, after this long prelude I have two questions:<o></o>

1. Is MSCAL.OCX the "culprit" for the error in the program?<o></o>

2. If it is, then what can be done to bypass this error? what is the best alternative?<o></o>

 

[RoryA]

You can only post code inside a post here - file attachments are not allowed. You can post the files on a free hosting site if you are allowed, or if you can email the files, I will PM you an address and take a look when I have time, and post any findings back here. Obviously a public file gives you more people looking at it though.

 

[PaxMundi]

Hi, rorya.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
As I've already mentioned, the program runs flawlessly on my computer (as well as on other machines). On the other hand, you are right when you point out that
" The fact that it works a couple of times [and then crashes] makes it sound like a code problem." <o></o>
IMHO, however, I think that in order to find the cause of the problem, the best thing to do is to run the program in its "environment". For that, you'll need both the entire program (.xlsm) file, and the 3 input (.xlsx) files.<o></o>
Now, since I'm not subscribed to any free hosting site, whom should I mail the files to? <o></o>​

 

[RoryA]

No need - I see you have posted them on one of the other sites you linked to, so I'll get them from there when I have time (assuming you don't get an answer elsewhere in the meantime)

 

[PaxMundi]

Thank you once again.

Please, read the "caveat" I wrote on that post..