problem with macro - trying to extract subjects from .msg files stored in folder

**mwilkes** · 12-10-2013, 06:33 PM

I pulled this code off the net:

Please Login or Register  to view this content.

I am getting "Run-time error '-2147467229 (80004023)': Automation Error A microsoft software installer error has occurred" on: Set olA = New Outlook.Application

Why is this happening? I am on office 2010 and have outlook object references set.

**Norie** · 12-10-2013, 06:45 PM

What happens if you replace that line with this?

Please Login or Register  to view this content.

**mwilkes** · 12-10-2013, 06:52 PM

same thing

debugger is showing ola = nothing

**Norie** · 12-10-2013, 06:57 PM

I'm afraid I can't find anything on that specific error but it kind of sounds like there's a problem with your installation of Office/Outlook.

**mwilkes** · 12-10-2013, 06:59 PM

its office 2010 64bit, never had any issues with it.

Do you know of another way to extract the subject lines of .msg files stored in a windows folder (not an outlook folder)?

**mwilkes** · 12-10-2013, 07:06 PM

Fixed it. Registry problem. I had 2007 before 2010.

problem with macro - trying to extract subjects from .msg files stored in folder

LinkBack

Thread Tools

Rate This Thread

Display

problem with macro - trying to extract subjects from .msg files stored in folder

Re: problem with macro - trying to extract subjects from .msg files stored in folder

Re: problem with macro - trying to extract subjects from .msg files stored in folder

Re: problem with macro - trying to extract subjects from .msg files stored in folder

Re: problem with macro - trying to extract subjects from .msg files stored in folder

Re: problem with macro - trying to extract subjects from .msg files stored in folder

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need Help for creating a Macro to extract specific data from all files in a folder.

Extract files from a folder using the names listed in a excel

[SOLVED] How to Extract .zip files stored in a folder using VBA

Macro to extract files in a given Folder

Copy a row from 3000 excel files stored in a folder and paste it in a new workbook

Bookmarks

Bookmarks

Posting Permissions