macro to fix missing:microsoft outlook 14.0 object library

[sujith]

can anyone help out in , macro to fix missing:microsoft outlook 14.0 object library

 

[GTO]

Hi there,

Go to Tools|References. Find the Missing:Microsoft Outlook 14.0 Object Library. Un-tick the checkbox. Scroll until your find the Outlook library with the version of Outlook that is installed on the machine you are using. Tick that one.

If you show us the code you are running, someone will most likely help by showing how to make some changes to the code so that running on different PCs doesn't result in this. In the VBA help, you will want to read about Late Binding vs. Early Binding.

Hope that helps,

Mark

 

[sujith]

Thanks for the replay.
Actually i need the macro to fix this issue, when i opens the workbook. i want to wrie the code in module that workbook_open().

Hi there,

Go to Tools|References. Find the Missing:Microsoft Outlook 14.0 Object Library. Un-tick the checkbox. Scroll until your find the Outlook library with the version of Outlook that is installed on the machine you are using. Tick that one.

If you show us the code you are running, someone will most likely help by showing how to make some changes to the code so that running on different PCs doesn't result in this. In the VBA help, you will want to read about Late Binding vs. Early Binding.

Hope that helps,

Mark

 

[Norie]

If you move to late-binding you won't have the issue.

 

[sujith]

I dont have much idea. can u please explain with code

If you move to late-binding you won't have the issue.

 

[Norie]

Can you post your code?

 

[shg]

Cross-posted at macro to fix missing:microsoft outlook 14.0 object library