Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error 400 - help

13 views
Skip to first unread message

ina

unread,
May 16, 2006, 12:22:56 PM5/16/06
to
Hello,

I have a strange error 400 and do not know from where come from.
Someone has an idea about it?

Ina

Tom Ogilvy

unread,
May 16, 2006, 12:50:01 PM5/16/06
to
In my experience, this is some intermittent error internal to Excel - not
directly related to your code although it may be stimulated by your code. I
would try shutting excel down and reopening it and see if it goes away.

--
Regards,
Tom Ogilvy

ina

unread,
May 17, 2006, 3:09:40 AM5/17/06
to
No I tried it but I do not know. I can not go on. do you thing I need
to select a specific reference.

Ina

ina

unread,
May 17, 2006, 3:17:07 AM5/17/06
to
I have this sub which erases everymodule and code I have before
saving, I do not know if it can be that:

Sub SaveAsWithoutCode()

Dim VBComp As VBIDE.VBComponent
Dim VBComps As VBIDE.VBComponents
Set VBComps = ActiveWorkbook.VBProject.VBComponents
For Each VBComp In VBComps
Select Case VBComp.Type
Case vbext_ct_StdModule, vbext_ct_MSForm, _
vbext_ct_ClassModule
VBComps.Remove VBComp
Case Else
With VBComp.CodeModule
.DeleteLines 1, .CountOfLines
End With
End Select
Next VBComp

End Sub

and I placed it normally here in the workbook_open:

Public Sub Save_Exit()

SaveAsWithoutCode
Application.Quit
ThisWorkbook.Close SaveChanges:=True
End Sub

0 new messages