"400" Error Message?

Question

I keep getting an "400" as an error messages after I try to run macros from my personal.xlsm from the QAT.  What the heck is "400"?

---

AthenaTree Goddess of Payroll Wisdom

Answer 1

Hi Mike and thanks for support,

the code is:

Sub Muestra_Aviso()

    On Error GoTo fin

    Archivo_Original = ActiveWorkbook.Name

    ActiveSheet.Range("A1").Select

    Dim Mensaje, Estilo, Título, Ayuda, Ctxt

    Dim Respuesta As Integer    ' columna As String, num As Integer, MiCadena as string

    Ayuda = "DEMO.HLP"    ' Define el archivo de ayuda.

    Ctxt = 1000    ' Define el tema

    ' state the message

    Mensaje = "This program will change your data. "

    Mensaje = Mensaje & "Do you really want to continue ?"

    Estilo = vbYesNo ' Define los botones.

    Título = "Cálculo de Horas Extras y Jornadas Nocturna y Normal"

    Respuesta = MsgBox(Mensaje, Estilo, Título, Ayuda, Ctxt)

    If Respuesta = 6 Then

        Call Program

    Else

        Exit Sub

    End If

fin:

    frm_BarraProgreso.Hide

    Exit Sub

End Sub

But the error appears before the messagebox,

The last time it appeared the error, it solved re-starting the computer.

Again, thanks for your interest, time and support.

Answer 2

Hi,

Post the code

---

If this post answers your question, please mark it as the Answer.

Mike H

Answer 3

Dear AthenaTree:

i have exactly your same problem, if you have found an answer, please tell it to me, it will be of great help.

Answer 4

Thank you Lars-Ake, for your quick reply

No--no form is being called or used, I am running the macro on a spreadsheet.  All I get is just a message box with a big red X and says "400".  Nothing else.  If I run the macro from the VBA editor it runs perfectly, but I can't run any macros from the QAT.  I get the same message "400".  I run this automation macro several times per month; it just cuts, pastes and sums ranges from another report. I added the macro to QAT so I could just push a button and whoppee my work is done. 

Any Help would be great!

Thank you

---

AthenaTree Goddess of Payroll Wisdom

Answer 5

http://support.microsoft.com/?kbid=146864

says

400 Form already displayed; can't show modally (version 97)

Hope this helps / Lars-Åke