View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
ina ina is offline
external usenet poster
 
Posts: 120
Default Error 400 - help

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