Compile Error

[JoanaChang]

I'm new at this !

I'm trying to use:

"Private part_tbl As Recordset"
....
"Dim appExcel As Excel.Application"
...

When I tried to run the code, its appears "User-defined type no
defined"

What I should do To define it?

 

[JuneTheSecond]

On Visio?
You might need to add regerence to the Microsoft ActiveX data object, and
Microsoft Excel Object Library.

 

[JoanaChang]

Thanks