Error when calling vb dll subroutine from excel vba

[Blaine]

I've created the following dll in vb 2008.
__________________________________________________ _________
Public Interface IDemo
Sub doSomething()
End Interface
Public Class implementIDemo
Implements IDemo
Dim varAsInterface As IDemo = New implementIDemo()
Dim varAsClass As implementIDemo = New implementIDemo()
Private Sub doSomething() Implements IDemo.doSomething
MsgBox("Hello")
End Sub
End Class
__________________________________________________ _________
I then used tlbexp.exe, gacutil.exe, regasm,exe, and sn.exe so that the
"doSomething" sub routine could be accessed/called from an excel vba (by
first referencing the tlb file).

My excel vba is as follows:

__________________________________________________ _________
Private moTemp As mydll.IDemo

Sub trial()
moTemp.doSomething
End Sub
__________________________________________________ _________

Excel VBA seems to recognize class and subfunction as I'm typing them,
but when I run the "trial" macro I get the following error:

"Run-time error '91': Object variable or With block variable not set"

Any ideas?

Thanks in advance,

*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Blaine,

I don't program in vba, but shouldn't it be:

Private moTemp As NEW mydll.IDemo

Or at least whatever facility vba has for creating a new instance?

Kerry Moorman
"Blaine" wrote:

I've created the following dll in vb 2008.
__________________________________________________ _________
Public Interface IDemo
Sub doSomething()
End Interface
Public Class implementIDemo
Implements IDemo
Dim varAsInterface As IDemo = New implementIDemo()
Dim varAsClass As implementIDemo = New implementIDemo()
Private Sub doSomething() Implements IDemo.doSomething
MsgBox("Hello")
End Sub
End Class
__________________________________________________ _________
I then used tlbexp.exe, gacutil.exe, regasm,exe, and sn.exe so that the
"doSomething" sub routine could be accessed/called from an excel vba (by
first referencing the tlb file).

My excel vba is as follows:

__________________________________________________ _________
Private moTemp As mydll.IDemo

Sub trial()
moTemp.doSomething
End Sub
__________________________________________________ _________

Excel VBA seems to recognize class and subfunction as I'm typing them,
but when I run the "trial" macro I get the following error:

"Run-time error '91': Object variable or With block variable not set"

Any ideas?

Thanks in advance,

*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Thanks for the reply Kerry.

When I use "Private moTemp As NEW mydll.IDemo" it produces the error
"Invalid use of NEW keyword"
*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Blaine,

Maybe the syntax is:

Private moTemp As mydll.IDemo

Sub trial()
Set moTemp = New mydll.IDemo
moTemp.doSomething
End Sub

Kerry Moorman
"Blaine" wrote:

Thanks for the reply Kerry.

When I use "Private moTemp As NEW mydll.IDemo" it produces the error
"Invalid use of NEW keyword"
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Kerry,

I'm still getting the "Invalid use of NEW keyword" error.

Thanks
*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?RmFtaWx5IFRyZWUgTWlrZQ==?=]

Shouldn't it be "new implimentIDemo"? Your IDemo is an interface, so you
have to create an actual class instance and cast it.

"Blaine" wrote:

>
Kerry,

I'm still getting the "Invalid use of NEW keyword" error.

Thanks
*** Sent via Developersdex http://www.developersdex.com ***

[kimiraikkonen]

On Aug 6, 9:11 pm, Blaine <[e-mail]:

Kerry,

I'm still getting the "Invalid use of NEW keyword" error.

Thanks

*** Sent via Developersdexhttp://www.developersdex.com***

Hi,
My guess would be that one or more of your references may be missing.
Make sure you added proper reference to your class library in solution
explorer by clicking "show all files" and expand "references".

BTW, are you using VB6 or lower,... or VB.NET? Because when you have a
missing reference the error message would be "Type '<typename>' is not
defined" on .NET.

Hope this helps,

Onur Güzel

[Blaine]

Mike,

I tried:

Dim motemp As mydll.IDemo

Sub trial()

Set motemp = New mydll.implementIDemo
motemp.doSomething

End Sub

is this what you were thinking? It's giving the following error:
"File or assembly name mydll, or one of its dependencies, was not
found."

Thanks,
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Hello Onur,

I am using vb 2008 express edition (it's the only thing that I have
access to).

Thanks
*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?RmFtaWx5IFRyZWUgTWlrZQ==?=]

Yes, that is what I had wanted you to try, but I don't know why the variable
motemp is declared outside the sub. As to the missing dependency, you should
look at Depends.exe that comes with visual studio. I think it may come with
express, but I'm not positive. It should tell you about missing dependencies
from the dll or exe.
"Blaine" wrote:

>
Mike,

I tried:

Dim motemp As mydll.IDemo

Sub trial()

Set motemp = New mydll.implementIDemo
motemp.doSomething

End Sub

is this what you were thinking? It's giving the following error:
"File or assembly name mydll, or one of its dependencies, was not
found."

Thanks,
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Mike,

I think you may be on to something. I ran the "Depends.exe", as you
suggested, and it gave me the following warnings about my dll:

1.)Warning: At least one delay-load dependency module was not found.

2.)Warning: At least one module has an unresolved import due to a
missing export function in a delay-load dependent module.

Also it said there was an error opening file "DWMAPI.DLL", the system
cannot find the file specified.

How do I add or fix this?

Thanks!
*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?RmFtaWx5IFRyZWUgTWlrZQ==?=]

Take a look at this site: http://dependencywalker.com/faq.html.

It looks like you have some depenency on IE 7 perhaps.

DWMAPI.dll is a Vista dll, to my knowledge. Are you running on Vista?
"Blaine" wrote:

>
Mike,

I think you may be on to something. I ran the "Depends.exe", as you
suggested, and it gave me the following warnings about my dll:

1.)Warning: At least one delay-load dependency module was not found.

2.)Warning: At least one module has an unresolved import due to a
missing export function in a delay-load dependent module.

Also it said there was an error opening file "DWMAPI.DLL", the system
cannot find the file specified.

How do I add or fix this?

Thanks!
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Mike,

I'm using Windows XP, SP2
*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?RmFtaWx5IFRyZWUgTWlrZQ==?=]

Searching for DWMAPI.Dll shows a lot of people running into this issue, but I
cannot say that I ever have. Here is a thread with a lot of information on
the subject:

http://forums.msdn.microsoft.com/en-...5f2bc2/#page:1

"Blaine" wrote:

>
Mike,

I'm using Windows XP, SP2
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Mike,

Thanks for the reply. I found the "DWMAPI.DLL" file and placed it in my
system32 folder and reused "Depends.exe" and the problem went away.
However, my excel vba still gives the missing assembly or dependencies
error. Any other ideas?

Thanks,
Blaine
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Mike,

Thanks for the reply. I found the "DWMAPI.DLL" file and placed it in my
system32 folder and reused "Depends.exe" and the problem went away.
However, my excel vba still gives the missing assembly or dependencies
error. Any other ideas?

Thanks,
Blaine
*** Sent via Developersdex http://www.developersdex.com ***

[=?Utf-8?B?RmFtaWx5IFRyZWUgTWlrZQ==?=]

I'm running low of ideas at the moment :( Sorry!

"Blaine" wrote:

>
Mike,

Thanks for the reply. I found the "DWMAPI.DLL" file and placed it in my
system32 folder and reused "Depends.exe" and the problem went away.
However, my excel vba still gives the missing assembly or dependencies
error. Any other ideas?

Thanks,
Blaine
*** Sent via Developersdex http://www.developersdex.com ***

[Blaine]

Mike,

Thanks for trying. Let me know if you think of anything.

*** Sent via Developersdex http://www.developersdex.com ***