New Version of Office and VBA

[GuavaHalf]

I have a very large and complex Access database with loads of VBA code. Will I be able to use it with the new version of Office due out later this year. I heard that they are dropping VBA and replacing it with something else.

[vehelpfulguy]

Here is the Office 2007 preview site from Microsoft

http://www.microsoft.com/office/preview/default.mspx

And here is the Office Developer Centre which may help

http://msdn.microsoft.com/office/

MS have just released Visual Studio 2005, and the Visual basic in that is very different. Not being a developer I have no more details.

[Gandy]

Yes, no problem. I have been trialling an Office 2007 Pre Release version and everything works fine. I did have a slight problem getting updates for the Outlook Object Library as there seems to be a slight difference with the MAPI function. Despite this I am really liking 2k7. Excel (which is the program I use mainly) has been given a facelift and works much better.