Cyberdude
01-12-2010, 12:07 PM
I'm still having problems with compile errors in Excel 2007 because (usually) ATPVBAEN can't be found. Sometimes the macro reference list shows that it's "MISSING". Explain please . . . Does "MISSING" mean that the compiler knows that what it's looking for is in ATPVBAEN, but it can't find the file on my computer??
I noticed that sometimes the name in the macro REFERENCES list has ".XLS" as the extension, and sometimes it has ".XLA". What's the difference?
Lately I've been getting compile errors when I use functions like DATE, CHR, and LEFT. These references are in old macros that have been running just fine for years in Excel 2003.
I'm finding it difficult to locate files in Windows 7. Where should ATPVBAEN be located and in 2007 what extension should it have?
Incidentally, I see that the 2010 version of Excel is available for download now.
I noticed that sometimes the name in the macro REFERENCES list has ".XLS" as the extension, and sometimes it has ".XLA". What's the difference?
Lately I've been getting compile errors when I use functions like DATE, CHR, and LEFT. These references are in old macros that have been running just fine for years in Excel 2003.
I'm finding it difficult to locate files in Windows 7. Where should ATPVBAEN be located and in 2007 what extension should it have?
Incidentally, I see that the 2010 version of Excel is available for download now.