Delete All VBA
 

Hi all,
I am trying Chip Pearson's VB Code for deleting all the VBA Code from a
workbook. But it gives me as error message.
Message is :
Compile Error:
User Defined Type is not defined.
Could anybody tell me why this type error occurred & is there any way to
resolve this as I am trying use the code on scheduled time.

Thanks in advance.

--
Thanks,
Vikram P. Dhemare

Delete All VBA
 

Read Chip's instructions once more.

You forgot to set a reference (and that's explained Chip's notes).

Vikram Dhemare wrote:

Hi all,
I am trying Chip Pearson's VB Code for deleting all the VBA Code from a
workbook. But it gives me as error message.
Message is :
Compile Error:
User Defined Type is not defined.
Could anybody tell me why this type error occurred & is there any way to
resolve this as I am trying use the code on scheduled time.

Thanks in advance.

--
Thanks,
Vikram P. Dhemare

--

Dave Peterson

Delete All VBA
 

Read Chip page good

Before using these procedures, you'll need to set a reference in VBA to the VBA Extensibility library

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vikram Dhemare" wrote in message ...
Hi all,
I am trying Chip Pearson's VB Code for deleting all the VBA Code from a
workbook. But it gives me as error message.
Message is :
Compile Error:
User Defined Type is not defined.
Could anybody tell me why this type error occurred & is there any way to
resolve this as I am trying use the code on scheduled time.

Thanks in advance.

--
Thanks,
Vikram P. Dhemare

Delete All VBA
 

Thanks for your early response.
I tried to set the reference in the reference diolog box but there is no
such VBA Extensibility Library available.
I am using Excel 2003.
Kindly revert where I am going wrong?

--
Thanks,
Vikram P. Dhemare


"Ron de Bruin" wrote:

Read Chip page good

Before using these procedures, you'll need to set a reference in VBA to the VBA Extensibility library

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Vikram Dhemare" wrote in message ...
Hi all,
I am trying Chip Pearson's VB Code for deleting all the VBA Code from a
workbook. But it gives me as error message.
Message is :
Compile Error:
User Defined Type is not defined.
Could anybody tell me why this type error occurred & is there any way to
resolve this as I am trying use the code on scheduled time.

Thanks in advance.

--
Thanks,
Vikram P. Dhemare

Delete All VBA
 

Hi Vikram,

Microsoft Visual Basic for Applications Extensibility 'Version'

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

Delete All VBA
 

Hi Helmut,
Thanks. Its working.
--
Thanks,
Vikram P. Dhemare


"Helmut Weber" wrote:

Hi Vikram,

Microsoft Visual Basic for Applications Extensibility 'Version'

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"