View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default VBA Converters Excel 2000 to Excel 2007

There are no converters that I've heard of to convert VBA to Excel 2007 VBA.
Excel 2007 VBA is the same as prior Excel versions, except for additions to
the object model and for slight (but frustrating) differences in what works.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"OldDog" wrote in message
ups.com...
Hi,

I have a lot of code samples written for Excel 2000. When I try to
load them into Excel 2007 I get this message:

"This workbook has lost its VBA project, ActiveX controls and any
other programmability-related features"

It then directs me to search for "VBA converters" on the Microsoft
Office site. When I go there, I can't find what I am looking for.
Either it does not exist or I can't read. Any help for converting
these useful samples to something that Excel 2007 can use?


Old Dog