Remove a module in VBA for Excel

Well, one error I just found is this:

Correct
  Workbooks(Books_to_do1)).VBProject.VBComponents(4).Remove
to
  Workbooks(Books_to_do1).VBProject.VBComponents(4).Remove

If this is not the answar you need, please type the errormessage (if any), not just the #

And in general correct

  ))
to
  )
That is, the number of ( should match the number of )

And you cannot break your code up as you seem to do:
  For Each M In Workbooks(Books_to_do1)).
  VBProject.VBComponents

It MUST be in one line

  For Each M In Workbooks(Books_to_do1).VBProject.VBComponents

Hej Martin,

Sorry, the missing ) was an error of mine. But was correct in the code. I didn't get any errors when compiling it. I found out what was wrong, or actually got some help from someone else.
I didn't refer to an object to remove.
The correct code is:

    Set Old_project = Workbooks(Books_to_do(1)).VBProject.VBComponents(Sheets(I).Name)
   
    Workbooks(Books_to_do(1)).VBProject.VBComponents.Remove Old_project

Thanks for your time anyway.
Agathe

How do I close this question by the way? (No need to mention I'm new at this..... ;-))

I ditn't offer any help, so place an answar of your own, and when your own answar appears, accept it, thereby givint all the points back to your self. An accepted question is a closed question. Best regards

Thanks