Delete Module In Another Workbook Problem

[stuartgb100]

Hi,
I open the Project workbook, and when conditions are met, a copy
of that workbook is made (UserWkbk).
So I now have two workbooks open.
The Project workbook code then calls the following sub:

Please Login or Register  to view this content.

I'm getting a subscript out of range error msg on the line:
Set VBComp .....

Can you help, please ?

[gmr4evr1]

Not sure about this, but, could it be the s at the end of components? In your declaration there is no s in component.

[stuartgb100]

Thanks - well spotted.

After correcting, I now get:

"Object doesn't support this property or method"

[gmr4evr1]

Did you remove the s from both components?

[Leith Ross]

Hello stuartgb100,

Your code syntax is correct as you first posted. The error is saying there is no VBComponent named "InitialiseOnOpenWorkbook" in the VBProject.

There are four basic types of VBComponents: Class Modules, Documents (These are Sheets), UserForms, and Standard Modules. Judging by the name used, I suspect you are trying to remove code from a worksheet.

It would help if you would explain in more detail what it is you wish to accomplish. Once I know what you want to do, I can help your more.

[stuartgb100]

gmr4evr1 - yes both 's' removed.

Leith, I am trying to delete a module named 'InitialiseOnOpenWorkbook'
This module is in a different workbook from the workbook doing the deletion.

I have discovered the problem - as you say, there is no such module found.

What I was trying to achieve, is as follows:

1. use vba to create a copy of the Project workbook
2. delete that particular module from the copy
3. save the copy

This is the copy code:

Please Login or Register  to view this content.

and then we move to the DeleteModule sub as first posted.

Just discovered that the copy workbook is named currently as Book1.
It seems as though it has worksheet code, but there are no modules and no
ThisWorkbook code - hence the subscript out of range error message.

Do I have to save this copy as a '.xlsm' filetype before I go any further with deleting that module ?

Thanks.