automated outlook reference in macro

keithkemble · Mar 12th, 2002, 01:23 PM

We run outlook 98 on laptops and outlook on dumb winterms on NT within our wan.

I have designed a sheet for application within the company.

It is possible to get the help desk to activate the outlook library within each persons excell.

Is there any way this could be coded into the macro to load the library automatically ?

My current application email without any issues.

Ivan F Moala · Mar 12th, 2002, 08:10 PM

Try this code before running the Outlook code

Sub RefLibrary_outlook()
On Error Resume Next
ThisWorkbook.VBProject.References.AddFromGuid _
"{00062FFF-0000-0000-C000-000000000046}", 9, 0

End Sub

NB: for Outlook 97 use 8 instead of 9

Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 01:23 PM	#1
keithkemble Board Regular Join Date: Feb 2002 Location: Leicestershire, U K Posts: 157	We run outlook 98 on laptops and outlook on dumb winterms on NT within our wan. I have designed a sheet for application within the company. It is possible to get the help desk to activate the outlook library within each persons excell. Is there any way this could be coded into the macro to load the library automatically ? My current application email without any issues.

Mar 12th, 2002, 08:10 PM	#2
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Try this code before running the Outlook code Sub RefLibrary_outlook() On Error Resume Next ThisWorkbook.VBProject.References.AddFromGuid _ "{00062FFF-0000-0000-C000-000000000046}", 9, 0 End Sub NB: for Outlook 97 use 8 instead of 9 Ivan