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

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

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" <(E-Mail Removed)> wrote in message news:FEB1A8F7-E738-4ABA-BAC7-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message news:FEB1A8F7-E738-4ABA-BAC7-(E-Mail Removed)...
> > 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
>

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"

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"
>