Outlook VBA text functions

V

Vaughan

I am getting an error message "Cant find project or library" when I try to
use text functions (specifically Format(date), Left(string)) in my Outlook
code. I know its crazy, but can anyone tell me what reference I may be
missing?

Thanks

Vaughan
 
E

Eric Legault [MVP - Outlook]

The missing module would be "Visual Basic For Applications". Strange that
you don't have it set; it should be there by default.
 
S

Sue Mosher [MVP-Outlook]

I've seen this happen occasionally. Usually restarting Outlook cures it

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
V

Vaughan

Thanks for the advice folks. It turns out that I have a reference to "Visual
Basic for Applications", and restarting Outlook didn't help I'm afraid. Maybe
the dll is corrupted. Do you know where I could download a copy from?
 
E

Eric Legault [MVP - Outlook]

Can you test just those functions only, without any Outlook objects, in the
Word or Excel VBA Editors?

If VBA isn't working their either, try uninstalling and reinstalling Visual
Basic For Applications under Office Shared Features in the Office setup
wizard.

--
Eric Legault (Outlook MVP, MCDBA, old school WOSA MCSD, B.A.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/
 
V

Vaughan

Yes I had a bitof a play and discovered it was only a problem in the "This
Outlook Session" module. I copied my code to another module and it works
fine. I don't have any reason to keep the code in This Outlook Session, so
I'm perfectly happy now, though I still don't really understand what happened.

Thanks for your help guys.

Vaughan
 
Top