| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA and Office Question
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA and Office Question
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 ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA and Office Question
Will the VBA code in Office XP work "as is" in Office 2007 or should we
expect to have to make programming changes? Thanks. "Charles Williams" wrote: 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 ... 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA and Office Question
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. -- __________________________________ HTH Bob "HISUser" wrote in message ... Will the VBA code in Office XP work "as is" in Office 2007 or should we expect to have to make programming changes? Thanks. "Charles Williams" wrote: 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 ... 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA and Office Question
Charles,
" 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 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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA and Office Question
Does the rest of MS know that Bill said that?
-- __________________________________ HTH Bob "Jim Cone" wrote in message ... Charles, " 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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office Assistant Question | Excel Programming | |||
| Question about Excel (Office) auditing/changes | Excel Programming | |||
| An old question about Office 97 to Office XP upgrades and Bloomberg | Excel Programming | |||
| A question for all of you Microsoft Office Specialists | Excel Discussion (Misc queries) | |||
| question about office web components in excel, | Excel Programming | |||
Hybrid Mode
