LinkBack URL
About LinkBacks
Hi, I will be downloading Visio and need to understand what is the best version to download (2007, 2010, 2013) if I am running Excel 2007.
Does it matter?
Hi, I will be downloading Visio and need to understand what is the best version to download (2007, 2010, 2013) if I am running Excel 2007.
Does it matter?
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
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
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 nowOriginally Posted by TMS
That's not very specific or helpful. What errors? What is the code doing? Are there any missing references?Downloading it has caused errors in my macro, its not recognizing Mapi folder now
Sorry TMS,
So this is the beggining of the code...
Essentially it is to Save Attachments...
Sub SaveEmailAttachmentsToFolder(OutlookFolderInInbox As String, _
ExtString As String, DestFolder As String)
The error I get is on this line...
Please Login or Register to view this content.
And the message reads....Please Login or Register to view this content.
Run-Time error '-2147319779(8002801d)':
Automation Error
Library not registered
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
I have the Msft Outlook Library selected and the OutlookFolder Inbox is defined as a String
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?
Everyone who confuses correlation and causation ends up dead.
I have not tried this...
Are there instructions on how to do so?
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.
I'm getting the message that MOfficse configuration did not complete succesfully...
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# )
The Link takes me to a blank MSFT page
So I unistalled the VISIO software and the code worked again. BUT the thing is now I need VISIO so do I re-install the 2007 version instead of 2010?
Logically, that would be the first thing to try.
So it's safe to say there is no fix with this type of error?
It boils down to adding un-compatible software causing these errors?
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks