Error 400

E

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.
 
S

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.
 
H

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
 
S

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.
 
K

kd

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

Steve said:
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.

Ernie Lippert said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top