Outlook 2007, VB or VBA?

[Rivelyn]

Hey all,

I have been digging around the internet and can't really find an answer.

VBA is dead, well at least MS is not developing it any further. I hear some chat that VBA scripts will not work in outlook 2007.

Currently the company I work for is using outlook 2000 with about 1k lines of vba code, and we are at the point of upgrading to 2007, or 2010 if it is available when we upgrade.

Is the VBA script going to work for the macro's?(essentially it is for our inhouse CRM, capture emails and insert into a database.)

Even if it does work, would this be a good opportunity to push for an upgrade, did I hear that straight up VB9 can be used in macro creation now?

[si_the_geek]

Thread moved from "Other BASIC" forum to "Office Development" forum

I have written some VBA macros in Outlook 2007, but as they weren't upgraded from Outlook 2000 I don't know what changes there are - I presume there will be some, most likely based around interacting with things like folders/messages.

[RobDog888]

The number one change that will affect you is the inclusion of increased security on accessing properties of certain objects.

Outlooks Security Prompt

Now to contridict that is that in 2007 MS has relaxed the amount of security prompting etc only if you are running an Anti-virus program. If you are not then all the security wil apply.

[Rivelyn]

Thanks for the answers, I guess what i will have to do is just drop our vba scripts into 2007 and just see what happens, if it's messy enough I will just re-write using vb9, which I would rather do anyway.

[RobDog888]

check my FAQ (link in signature) for how to with .net.