VBA and Office Question

H

HISUser

We current use Office XP and have no immediate plans to migrate to a more
current version of Office.

We have Word and Excel documents that use a lot of VBA code.

Will VBA code be supported in Office 2007? Will VBA code be supported in
later versions of Office? Does Microsoft have a project lifecycle that
states how long VBA code will be supported?

Is VSTO the VBA replacement? Will VSTO work in Office XP? To go from VBA
to VSTO will we have to rewrite all of the VBA code (similar to the extensive
rewriting required for VB6 to DotNet)?

Thanks
 
C

Charles Williams

VBA is supported in Office 2007.

The official public Bill Gates statement on how long VBA will be supported
in Office is "forever"

VSTO is not the VBA replacemen, its targeted at .NET programmers who want to
access Office objects.

To use VSTO you have to convert all your VBA code to .NET


Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com
 
H

HISUser

Will the VBA code in Office XP work "as is" in Office 2007 or should we
expect to have to make programming changes?

Thanks.
 
J

Jim Cone

Charles,
Re: " The official public Bill Gates statement on how long VBA will be supported
in Office is "forever" "

I wonder if Bill ever tried to modify the Office 2007 Ribbon using VBA?
Or maybe he was just practicing up for a run for public office? <g>
--
Jim Cone
Portland, Oregon USA



"Charles Williams"
wrote in message
VBA is supported in Office 2007.
The official public Bill Gates statement on how long VBA will be supported
in Office is "forever"
VSTO is not the VBA replacemen, its targeted at .NET programmers who want to
access Office objects.
To use VSTO you have to convert all your VBA code to .NET
Charles
The Excel Calculation Site
http://www.decisionmodels.com



"HISUser"
wrote in message
 
B

Bob Phillips

You might need to make some changes, you will just have to test it. Some
people get away with very few, some need more changes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How will we create UDF's on 64 bit OS after support for VBA is dro 6
Best Excel Development Architecture? VSTO vs. VBA vs. VB.Net/C#.Netvs. ??? 1
Trouble Installing Excel VBA Code Cleaner into Office 365 0
What is planned to replace VBA? 8
Moving from VBA to VSTO 1
VSTO Excel with Autoshapes, Connectors and Polylines on Worksheet? 3
Cannot find a loaded VBA addin 3
VSTO 2.0 vs Excel VBA 1

Top