I know that there are some items that don't work in the new format.
I.e., if you're calling to a macro in a different module, or location, you
no longer use application.run ().
Now, you only need to use Call "macroname"

Other than that, most (like 95%+) of my old 2000 code worked fine brining it
into 2007 simply by saving my xlb, or xls files housing my macros into xlsb.


"Ernie Lippert" wrote:

I recently installed Excell 2007. When Personal.xls [Compatibility Mode]
opens, I get a Microsoft Visual Basic Error 400. The Help menu is not that
much help. What can I do to avoid the 400 error? I have a fairly large amount
of code in different worksheets. Exiting out of the error message box doesn't
seem to do any violence to the execution of the codes.
--
Regards,
Ernie Lippert