LateBinding and "Type not found"

Can someone think along with me on this one? The module I am working on calls Excell from AutoCAD. Excel does a lot of things, then exports the result to a .txt file, wich is then used to make a drawing.

A sub that I call (using late binding) is causing some problem I can't find a solution to. I should be able to dim a Range with a dimmed "excel.application" (xlapp = Excel.application). But it doesn 't work. I get a compile error: "user defined type not defined" when it runs into the latebound Range I dimmed.

Please Login or Register  to view this content.

I tried to get the program to recognise the "range" object like this:
Dim rng As Object
Set rng = CreateObject("Excel.Range")

To no avail, the ActiveX couldn't create the object.
Somehow I can't get it to recognise the Range when I put xlapp. in front of it.
Without it, it works fine. But that will leave Excel running, wich is not an option.

You don't need to create a range, you are just setting a variable referencing a range.

If you are using late binding, then you cannot use the explicit datatype, you have to use the generic object

Please Login or Register  to view this content.

Originally Posted by Hung

Thanks for the pointers. I was looking in the wrong direction for too long. This was the solution to the problem:

Please Login or Register  to view this content.

Range was the problem, but the reason for that was caused elsewhere.

Surely, you don't need xlApp and Application, xlApp is the Application object.