I know nothing about jmp but from the line of code and the message I can tell
that you need to have a reference to the jmp object library added to your
project. That would be in the VBA editor, go to Tools... References. Scroll
down the list and see if you can see it listed there. It might appear under
j for jmp or perhaps under the developer's name. If you have it there, check
off the checkbox and press OK and you should be set. If not you will need to
do some research: is the library file supplied with the app? If so, where on
your disk is the file stored? If not, how do you get it and does it need to
be licensed.
--
- K Dales


" wrote:

I am trying to use a macro found on the internet to automate jmp stat
analysis package through excel.

http://www.jmp.com/news/jmpercable/0...001/Excel.html
However, the statement below errors out saying the user-defined type is
not defined. Can anyone suggest a remedy.

Public JMPDoc As JMP.Document

thank you for you time