Downloading Visio and connecting to excel 2007

Logically, the most recent version would be expected to be the best. Especially, if it has new features that you want to use ... and you are prepared to believe that any new(ish) product from Microsoft (or anyone, for that matter) works perfectly out of the box from day one. And it SHOULD be backwards compatible, shouldn't it?

That said, you would expect programs from the same version to be compatible, and tested together.

And, finally, how much use of interaction between the products will you plan to make?

Just some thoughts. Probably doesn't help much. I'd be inclined to go with 2007. But then I'm not very adventurous or an "early adopter".

Regards, TMS

One other thought. Does the output need to be used by colleagues, clients, suppliers, whatever? If it does, I'd suggest you opt for compatibility with the majority.

Downloading it has caused errors in my macro, its not recognizing Mapi folder now

That's not very specific or helpful. What errors? What is the code doing? Are there any missing references?

Well, you need a reference to the Microsoft Outlook xx Object Library. Do you have that? Or is it marked as missing?

And the variable OutlookFolderInInbox is not defined. So, that may be a problem, too.

Regards, TMS

This works for me in excel 2007/Outlook 2007 with a reference to the Microsoft Outlook 12.0 Object Library. I also have Visio 2007 installed.

What version of Visio did you download? presumably, the code worked before you downloaded Visio. If you uninstall Visio, does it work again?

Please Login or Register  to view this content.

I have asked for input from other forum members.

See OP's follow up thread here: http://www.excelforum.com/excel-prog...ing-error.html

I have also raised this here: http://www.excelforum.com/the-water-...ml#post3958974


Please consider this thread CLOSED NOT SOLVED. If you have any thoughts or suggestions, post in the new thread.

Regards, TMS

Have you tried repairing Office through the Control Panel?

Go into Control Panel, choose Programs and Features (or the equivalent for your OS), locate the Microsoft Office entry and click the Change button, then choose to perform a repair.

Sounds like your installation has gone wrong then. You may need to remove, reboot and reinstall from scratch. (There's instructions and a FixIt here if you have problems doing it from Control Panel: http://support.microsoft.com/kb/928218# )

Logically, that would be the first thing to try.

It is not necessarily incompatible. But, as you can imagine, a suite of programs will, most likely, have been tested for compatibility. Each version will have its own libraries and common routines. So, chances are the programs are likely to work better together than if you take a mix and match approach.