This sounds more like a problem with Excel 2007 trying to read the 2000 files
than of 2007 not being able to deal with the code. While most of my stuff
that's non-2007 is in 2003 files, I haven't experienced anything similar with
opening older files. As a matter of fact, many, if not most, of my 2003
files get saved out as 97-2003 format and 2007 hasn't had any trouble opening
them or using the code in them except for some charting/graphing stuff.

If you've still got 2000 installed somewhere, you might try opening a couple
of those troublesome files and saving them out in the 97-2000 format and
seeing if 2007 doesn't deal with them better.

You might also try running the Excel 2007 diagnostics to see if some repair
of the installation may be needed: Excel's Office Button - Excel Options -
Resources and there is a "run Microsoft Office Diagnostics" option there.

"OldDog" wrote:

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