using VB6 to work with Excel

[AM003295]

I am useing a VB6 program to open and read an Excel workbook, to do this I have selected the Reference "Microsoft Excel 11.0 Object Library" under my project references, and in my code I have the following line:
Set appEx = CreateObject("Excel.Application")
Which I belive creates the excel object. However when I try and run this I get an error of: "Compile error: Variable not defined" for the appEx =

I do not have appEx defined but then in my other programs I don't seem to have it defined either and things work ok in them. What am I missing here? what do I need other then the Excel Reference object library?

[Phil Weber]

Do you have Option Explicit at the top of your code? If so, you must declare each variable before you use it.

[AM003295]

Very good,
I now have appEx definded as an object and all works great.

thanks I really leaned something from this. In the past I was just "using stuff" that worked