Delete All VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Read Chip's instructions once more.

You forgot to set a reference (and that's explained Chip's notes).
 
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 said:
Read Chip page good
Click to expand...
 
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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete defined names with errors using VBA 1
Delete all modules and forms from workbook 2
Compile Error:Variable not defined 4
VBA Range.Formula 6
Delete rows based on contents of Col A 0
Excel VBA 1
index function in vba 3
How to set focus on an ActiveX ListBox 7

Back
Top