automation error, missing my.show (Win XP Word 200

(Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>)

We use a very old macro from slipstick call My Outlook Calendar (http://www.slipstick.com/files/myolcal.zip) that makes a nice, easily updated web calendar from our Outlook calendars. Even though it is a Word 98 macro, it still works fine with Word 2003. Or it did, until yesterday. Yesterday we discovered a bunch of virus infections and installed Symantecs latest Norton Internet Protector 2006. It cleared a bunch of stuff. But now My Outlook Calendar won't run any more.

When you run MyOlCal (it's a word template with embedded macros) you get the typical dialog asking if you want to enable the macros. When you do enable them it sits a moment and then you get a dialog box stating " Run time error '-2177024770(8007007e)'; Automation Error, the specified module could not be found". It then offers End or Debug buttons. I don't know much about debug but when you choose that the editor seems to indicate it is looking for a module named My.Show which cannot be found. I tried reloading MyOlCal and also the VB6 runtimes. None of that helped.

Oh, the machine with this problem has both Word 2000 and Word 2003. Same thing happens with both/either.

Re: automation error, missing my.show (Win XP Word 200

Activate the Visual Basic Editor (Alt+F11)
You should see MyOutlookCalendar in the Explorer-like treeview on the left hand side. If you expand it, you should see something like the screenshot below. Are MY under Forms and Cal under Modules present?

Re: automation error, missing my.show (Win XP Word

Hi. Hope you haven't retired and run off to Zanzibar. Still need your help with this one.

Yes, as you suggested I did the repair for Office (both 2000 and 2003). Still My Outlook Calendar fails with the Automation Error message. Based on a Google search on that error I reinstalled Windows Scripting Host and tested the MDAC version. Still no soap.

Today I threw up my hands and went looking for other printing apps. Amazingly, all the others I find are also Word macros. But I decided to try them. One is Outcal.dot and the other is OlCalndr.dot. They react the same as each other but differently from MyOlCal.

With MyOlCal, the macro blows up before the input/control form comes up. (The form is the module named MY.) With these two new macros, the form comes up and allows you to make your selections. But when you tell it to make a calendar it reports that 'Outlook must be open and a calendar selected' for them to work and then crashes out. So, apparently they cannot see that Outlook is there. I wonder if it is the same error and just a different error message for MyOlCal? And if true, what can be causing this?

On the other computer in the office, where MyOlCal still works fine, the other two programs also work just fine.

Re: automation error, missing my.show (Win XP Word

The End of the Story

Well, based on the impression from the two new programs that they simply could not see Outlook, I decided to take action. I had already done a repair install of Office 2003 but this time I literally uninstalled Outlook and then installed it. And that did the trick.