Hi Guys,

How can I delete the code in one workbook from another workbook.

Take two workbooks A & B

Workbook A has lots of code and modules and is protected with a project
password (which I know).

I want workbook B to be able to access the vba project in workbook A and
delete all vba modules and code. Any ideas?

many Thanks L

If the code is protected then you are hooped. Otherwise you need to get a
reference to the target workbook something like

dim wbk as workbook

set wbk = workbooks("MyBook.xls")

after that you can use the code that is refered to here...
http://www.cpearson.com/excel/vbe.htm

--
HTH...

Jim Thomlinson


"Libby" wrote:

Hi Guys,

How can I delete the code in one workbook from another workbook.

Take two workbooks A & B

Workbook A has lots of code and modules and is protected with a project
password (which I know).

I want workbook B to be able to access the vba project in workbook A and
delete all vba modules and code. Any ideas?

many Thanks L