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>

 

[VoG]

Hi. Version 11 works fine with Excel 2010 and Windows 7 - see the Excel 2003 version here http://www.fontstuff.com/mailbag/qvba01.htm

If you are running Windows 7 64 bit you will need to follow the second post by Jay Freedman http://social.answers.microsoft.com...g/thread/03ad5d05-ca3f-4081-9989-e757223ebdde to register it.

It will not work with Excel 2010 64 bit.

 

[PaxMundi]

Hi, Peter!
Thanks for your prompt reply.
The machine is running 32-bit Windows 7, so I hope I won't have any problems.
I'll probably know better tomorrow...

 

[PaxMundi]

I've installed today another version of the program (this time, without MSCAL.OCX) but the problem recurs (which proves that it has nothing to do with the calendar).
The behaviour is quite bizarre: The program executes smoothly exactly twice (!!!) and then fails to execute again, displaying an error message. In order to run the program again, one has to exit EXCEL altogether and then re-run the program (either via an icon configured in the QAT = Quick Access Toolbar) or by opening the workbook "hosting" the program and clicking on a button, which executes the macro).​

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>

While in debug mode, I put the debug.print error.number statement before and after the first statement in the code (Form.show vbmodal) and it seems that error is generated while trying to execute this very statement (i.e. Form.show): I get the 21472221232 error number in the immediate window.<o></o>

<o></o>

Some "googling" produced the following result:<o></o>

<o></o>

Automation Error &H80040110 (-2147221232) Class does not support aggregation (or class object is remote).<o></o>​

<o></o>

I would appreciate it very much if someone could explain what causes the problem and how it should be resolved.<o></o>

<o></o>

<o></o>

<o></o>

 

[mole999]

vbModal might give some clues, you can force an event in MSAccess to stay at the top of the screen and not progress until the user provides an answer, maybe something is being opened not visible and hold the whole operation up

thats about my limit with that type of issue

 

[PaxMundi]

Thanks, Mole

Unfortunately, changing the "modality" of the form doesn't make any differnece.

 

[RoryA]

The fact that it works a couple of times makes it sound like a code problem. Since you haven't posted any, it's hard to comment further.

Also, if you are going to cross-post in several forums, it's common courtesy to provide links to the other posts so we don't duplicate effort or repeat suggestions.

 

[PaxMundi]

Thank you, Rorya.

First, A word of apology.I should have notified the forum that the problem I posted was also posted in other Excel Forums:
1. http://www.ozgrid.com/forum/forumdisplay.php?f=8

2. http://www.vbaexpress.com/forum/forumdisplay.php?f=17

3. http://www.excelforum.com/excel-programming/

4. http://social.msdn.microsoft.com/Forums/en-US/exceldev/threads

I agree that this info should have been disclosed, but since this was the first time that I posted a question to any Forum, I was not familiar with the rules and the etiquette.

Secondly, I would appreciate it very much if you (or somebody else) could have a look in my code. Please tell me if it's OK to upload the program's code.

Best regards,
PaxMundi@gmail.com

 

[RoryA]

It is fine to post the code. If there is a lot of it, you may want to post the actual workbook somewhere (after removing any confidential data!).
I also suggest you do not ever put your email address in a post unless you like spam.

 

[PaxMundi]

Thank you, Rorya, for your prompt reply.
1. I don't really know how to determine whether my code is "a lot of" or not. I have one module Module1 (760 lines of code) and 2 forms: FrmMain (415 lines) + frmBrnchList (130 lines).

2. In addition to the program, 3 input files should be attached in order to execute the program. However, I must consult with my customer and accept his explicit permission in order to send these files, as they might contain some business-sentive information.

3. I haven't found any explanation concerning upload of files,modules, forms etc. Would you kindly clarify this issue?

Best regards (and thanks for the e-mail address tip)