Outlook 2003 - macros have disappeared

[Mirsten Choiple]

My macros have disappeared and there is no response from Tools, Macros,
Visual Basic Editor.

Detect and repair hasn't fixed the problem.

A search of the hard drive shows the .OTM file is still there.

Any ideas, anyone?

David

 

[Michael Bauer]

Hi David,

try click on ?->Info->Deactivated Elements

and activate the VBA-Addin.

Do you use in your script CreateObject(,"Outlook.Application")?
Sometimes it happens that this causes an fatal exception when closing
OL, and OL asks you when next starting, whether it shall deactivate VBA.

(I´ve never experienced that myself, but heared. HTH.)

 

[Mirsten Choiple]

Michael

Thank you very much for your help.

That solved the problem.

regards,
David

 

[Wayne Ivory]

Today I started having the same problem - no macros - but after an
hour of looking I can't find the ?->Info->Deactivated Elements link
mentioned below. The "?" I presume is the white question mark in a
white circle with a blue background that I see on the right of all the
Outlook buttons. When I press that I get what Outlook calls a Task
Pane with a heading of Outlook Help on the right edge of Outlook. In
this pane there is a Search box as well as links for "Table of
Contents", "Connect to Microsoft Office Online", "Get the latest news
about using Outlook", "Get online training for Outlook", "Assistance",
"Training", "Communities", "Downloads", "What's New", "Contact Us",
"Accessibility Help", "Online Content Settings". None of these seem
to give me the choice mentioned by the other posters.

Can someone please point me in the right direction.

Thanks

Wayne Ivory
IT Analyst Programmer
Wespine Industries Pty Ltd

 

[Michael Bauer]

Hi Wayne,

it´s the "?" on the top menu bar. There are "File", "Edit", etc. The "?"
is the most right item.

 

[Wayne Ivory]

Hi Michael,

Thanks for the reply. I don't have a "?" on the menu bar, only on the
toolbar, however I suspect they do the same thing (perhaps there is a
version difference - I'm on Outlook 2003 SP1). But the problem is
when I press the "?" I don't see the Info->Deactivated Elements link.
Maybe it's buried somewhere or there is another way to access it??

Thanks

Wayne

 

[jbairen]

look in Help -> About Outlook

 

[Wayne Ivory]

Thanks John, I found the button for Disabled Items. However it said
there are no disabled items so I still have my original problem, ie
macros disappeared. Any other suggestions please anyone?

Thanks

Wayne

 

[jbairen]

Wayne,

How did you install Outlook 2003 (or Office 2003)? Was it a fresh
install or an upgrade of Outlook/Office XP? If it was an upgrade, did
you leave XP on and install so that you have both versions? If this is
so check out my other post here:

http://groups-beta.google.com/group..._doneTitle=Back+to+Search&&d#5754d3c1cfbab8dc

or search this group for "Outlook 2003 Visual Basic Editor / Macros
Crash (solution!)"

Let me know...

 

[Wayne Ivory]

Thanks for sticking with me on this one John.

This is not a new install or an upgrade. 2003 was installed several
months ago and has been working fine up until the other day when the
macros mysteriously were no longer there. As far as I'm aware nothing
changed (although I'm aware that's rarely the actual case in these
situations).

One other piece of information I've just thought to include: In
Outlook pressing Alt-F11 gives me the Enable/Disable macros prompt,
and after clicking Enable I get an error message "File not found".
That's all, no indication of what file it is looking for, just an OK
and a Help button. Clicking Help gives a generic Error 53 description
"A statement, for example, Kill, Name, or Open, refers to a file that
doesn't exist." Clicking OK does nothing. Pressing Alt-F11 again
opens the VBA IDE environment. The Project Explorer pane is empty
with the title No Open Projects.

Regards

Wayne

 

[jbairen]

Wayne,

Have you tried to reinstall or repair your current install? If a file
is missing, that might help.

 

[Michael Bauer]

Maybe it helps via remove/install features to remove the VBA support
only and re-install then.

Another suggestion: Search for an existing *.otm file and move or rename
it.

 

[jbairen]

Also... I just read this post that **might** help:

http://groups-beta.google.com/group..._doneTitle=Back+to+Search&&d#cb9011126a8571e8

 

[jbairen]

For whatever reason, the link in my last post pasted in wrong. So try
this link:

http://tinyurl.com/7y7z2

 

[Devdex Feig]

Michael,

Thanks for all of your emails on this subject... I have the same problem
as Wayne and let me tell you it has been tough to find a solution.

Your last suggestion to move or rename the existing .otm file (for me
this is C:\Documents and Settings\David\Application
Data\Microsoft\Outlook\VbaProject.OTM) did the trick.

Thanks for you help and thanks to all of the people who provide free
assistance in discussions like this.

--David

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Michael Bauer]

Hi David,

thanks for your feedback!

 

[Wayne Ivory]

Hi guys,

I've been away for awhile so I've just got around to trying this. I
renamed my VBAProject.OTM to VBAProjectBad.OTM and I'm now able to
successfully open the VBA IDE environment. Of course it is "empty"
and I know I'm pushing my luck here, but do you have any suggestions
for extracting the macros I had out of the Bad OTM?

Thanks

Wayne

 

[Michael Bauer]

Hi Wayne,

try this: write any dummy code in ThisOutlookSession, save & run the
code. After that you can delete the dummy project and re-rename your
*bad.otm. Maybe it works.

 

[Wayne Ivory]

I wrote a Test subroutine and saved it and ran it okay. But Windows
XP wouldn't let me delete or rename VbaProject.OTM because it was in
use - I had to close Outlook first. Then when I renamed it and
renamed the bad one to the original I was back where I started, ie no
macros.

Regards

Wayne

 

[Michael Bauer]

Hi Wayne,

sorry, I´ve no more ideas :-( It´s unnecessary to mention the
importance of backups...