How to create a object of java class in excel vba

Question

Hi

i have a java class..i have registered in my system(it has shown the message as
registed successfully)..but when i try to create an object(the code is as below)
It is throwing error as module not found..do i have set the path.if yes how..

Dim conn
set conn = createObject("Main")

Main is the java class which is in C:\windows\java\trustlib

Please help me out..i am new to excel vba

Answer 1

See this description of CreateObject. Your code should look like this

Dim conn
Set conn = CreateObject("<server>.Main")

Where <server> is the name of the application providing the object.