ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to do this? (https://www.excelbanter.com/excel-programming/313453-how-do.html)

sungen99[_14_]

How to do this?
 

AHHH. I did this once before for a program that I was working on. I a
now working on another but forgot how to do this:

'You must add a reference to the Microsoft outlook Library'

Where do I do this again please

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=26899


Tom Ogilvy

How to do this?
 
go into the VBE (Alt + F11)

make sure the workbook that needs the reference is the active project (one
part of it is highlighted in the Project Explorer).

then do

Tools=References

scroll down until you find Microsoft Outlook . . .

click the checkbox and click OK.

--
Regards,
Tom Ogilvy


"sungen99" wrote in message
...

AHHH. I did this once before for a program that I was working on. I am
now working on another but forgot how to do this:

'You must add a reference to the Microsoft outlook Library'

Where do I do this again please?


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:

http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=268992




Bob Phillips[_6_]

How to do this?
 
or you use late binding.

--

HTH

RP

"sungen99" wrote in message
...

AHHH. I did this once before for a program that I was working on. I am
now working on another but forgot how to do this:

'You must add a reference to the Microsoft outlook Library'

Where do I do this again please?


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:

http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=268992





All times are GMT +1. The time now is 02:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com