• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

Compile error when running macro from 2007

Hi Experts

Here is the macro originally created with link:- http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27990107.html

The problem I am having is the macro us not working in 2007
Getting compile error "User-defined type not defined"

Public sub SaveAttachments ()

Dim objOL as outlook.Application

How do you correct / fix this???
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you have to add the microsoft outlook in the project references.
route217Author Commented:
Ok makes sense....
Thanks for feedback..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now