I typed Dim doFName As DataObject. When I stepped through the code and it
hit this line, I get:
Compile Error:
User-defined type not defined

Isn't DataObject defined in Excel? Have I failed to reference the right
library? Any suggestions?

Ed

Ed,

Do you have a reference to the 'Forms' library for the file that
contains the code?

Paul

-------------------------------------------

I typed Dim doFName As DataObject. When I stepped through the code and it
hit this line, I get:
Compile Error:
User-defined type not defined

Isn't DataObject defined in Excel? Have I failed to reference the right
library? Any suggestions?

Ed

Ed

Reference the Microsoft Forms 2.0 Library.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Ed" wrote in message
...
I typed Dim doFName As DataObject. When I stepped through the code and it
hit this line, I get:
Compile Error:
User-defined type not defined

Isn't DataObject defined in Excel? Have I failed to reference the right
library? Any suggestions?

Ed

Thank you, Dick and Paul. That did the trick!

Ed

"Dick Kusleika" wrote in message
...
Ed

Reference the Microsoft Forms 2.0 Library.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Ed" wrote in message
...
I typed Dim doFName As DataObject. When I stepped through the code and
it
hit this line, I get:
Compile Error:
User-defined type not defined

Isn't DataObject defined in Excel? Have I failed to reference the right
library? Any suggestions?

Ed