What Changes can we expect in Excel 2010 VBA

[Hooseria]

Does anyone know of a good website to check out new changes in VBA on Excel 2010.

Or better yet, any MVP's out there have any insight you want to share with us.

 

[RoryA]

VBA will still be supported (unless you're on a Mac, in which case who knows?) and there are currently no plans to change that.

 

[Stray__CAt]

Actually I think that there's not going to be any change. VBA is growing old quickly.
We all should focus on VSTO in the near future.

 

[Domski]

Actually I think that there's not going to be any change. VBA is growing old quickly.
We all should focus on VSTO in the near future.

Maybe not all. I'll stick with VBA for a good few years I think, I've barely got a handle on that after all!!!

 

[Greg Truby]

As Rory has stated, those of us who know what they're thinking cannot say. What we can tell you is to be observant. When was VBA introduced into Excel? Can you still use XLM commands? Can you still create a macro sheet and/or dialog a la XL95 way? That should give you some inkling as to how long VBA will continue to be supported in Excel.

 

[Smitty]

I think it's safe to say Microsoft has no plans on killing off VBA any time soon. In fact they will continue to add functionality to it to support the Ribbon functionality and new features in Excel. What they won't be doing is any work to upgrade the current IDE itself.

As for what's coming in 2010, like Rory and Greg said, you'll just have to wait and see.

 

[Colin Legg]

Just a couple of 'useful' links re Excel 2010:

Microsoft Office 2010 client Forum:
http://social.technet.microsoft.com/Forums/en-US/office2010general/threads

2010 teaser movie:
http://www.office2010themovie.com/

 

[delaneyjm]

Saw this the other day on Wikipedia and thought some might be interested. Although, I DO take everything I read on Wikipedia with a grain of salt:

In May 2008, Microsoft announced that VBA will be making a return in the next version of Microsoft Office for Mac.

Here's hoping it's in the 2010 version.

 

[SydneyGeek]

For a start I hope they bring back FileSearch!

Problem is, if they do, you still have to write code that works in 2007. Dumb mistake on their part, but IMO, FileSearch is now dead.

Denis

 

[Norie]

I actually hope they don't bring back FileSearch.

Sure it was kind of convenient but I've lost count of the times in the past when I used it and the results just weren't right.

 

[Oorang]

Some of the changes so far: http://www.vbaexpress.com/forum/announcement.php?f=43