Error 400

[Ernie Lippert]

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.

 

[Steve]

Hi ernie,
Save your personal.xls file as a personal.xlsb format.
It's one of the new eccentricities of excel 2007.
I'd encourage you also to read up on the new formats.
http://www.google.com/search?q=exce...icrosoft:en-US&ie=utf8&oe=utf8&rlz=1I7GGLD_en

If you have any xla formatted files, they become xlam. the new standard
format of xlsx will not allow the user to store macros in the individual
files. The new format for that is xlsm.
Essentiallly, if you want your macros to remain global macros, they need to
be placed in an xlsb file.
hth.
Is so please click yes.
Thanks.
Best.

 

[Homey]

problem not with file format. old format works ok in 2007. problem is with
code. what line say where error happen?

|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

 

[Steve]

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.

 

[kd]

If you paste your data- usuing paste special/ values only then you shouldb e
able to avoid the Error code

Hi ernie,
Save your personal.xls file as a personal.xlsb format.
It's one of the new eccentricities of excel 2007.
I'd encourage you also to read up on the new formats.
http://www.google.com/search?q=exce...icrosoft:en-US&ie=utf8&oe=utf8&rlz=1I7GGLD_en

If you have any xla formatted files, they become xlam. the new standard
format of xlsx will not allow the user to store macros in the individual
files. The new format for that is xlsm.
Essentiallly, if you want your macros to remain global macros, they need to
be placed in an xlsb file.
hth.
Is so please click yes.
Thanks.
Best.

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.