Compile error

[Danielf]

Hi,

I have the following code in an form:

Dim appExcel As Excel.Application

the purpose of the code is to open an excel file.

When I am running the form, I am receiving the following error:

" Compile error
user defined type not defined"

Where is my error?

Thanks for help.

Daniel

 

[chergh]

Have you added a reference to excel object library?

 

[Danielf]

Have you added a reference to excel object library?

No , I have no idea how to do this.

Daniel

 

[chergh]

Go to the tools menu in the VB editor and select references. go through that list till you find the microsoft excel object library and check the box next to it.

 

[Danielf]

Go to the tools menu in the VB editor and select references. go through that list till you find the microsoft excel object library and check the box next to it.

Hi Chergh,

Thanks a lot, it works

Have a nice day

Daniel