How do I make my other Microsoft Applications like Outlook access.
 

I am trying to access Microsoft Outlook in my VBA code in the excel sheet for
Microsoft Office 2000.But I get a compile error. It seems because Outlook is
not allowing access to the VBA Project.
In Microsoft 2002 + , we have a checkbox "Trust access to Visual Basic
Project".But this is missing in Microsoft Excel 2000 version.
Now how do I get rid of this error.

Rohit

How do I make my other Microsoft Applications like Outlook access.
 

Where is the code, and which line errors?


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rohit Satabhai" <Rohit wrote in message
...
I am trying to access Microsoft Outlook in my VBA code in the excel sheet
for
Microsoft Office 2000.But I get a compile error. It seems because Outlook
is
not allowing access to the VBA Project.
In Microsoft 2002 + , we have a checkbox "Trust access to Visual Basic
Project".But this is missing in Microsoft Excel 2000 version.
Now how do I get rid of this error.

Rohit

How do I make my other Microsoft Applications like Outlook access.
 

You wouldn't get a compiler error if it were a matter of trusting
access to the VB Project. You'd get a runtime error. Post the
code that is causing the compiler error, and specify exactly what
the message says.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Rohit Satabhai" <Rohit wrote
in message
...
I am trying to access Microsoft Outlook in my VBA code in the
excel sheet for
Microsoft Office 2000.But I get a compile error. It seems
because Outlook is
not allowing access to the VBA Project.
In Microsoft 2002 + , we have a checkbox "Trust access to
Visual Basic
Project".But this is missing in Microsoft Excel 2000 version.
Now how do I get rid of this error.

Rohit