Function Pointer in VBA.

[Akihito Yamashiro]

This is not a question.
I summarized in the following URL about the way to use a function pointer in Excel VBA.
If you like, see it, please.

http://akihitoyamashiro.com/en/VBA/FunctionPointer.htm

 

[Steve VBA]

Is this what is commonly known as SPAM by any chance ? Atleast try to hide it by answering a somewhat relevant question with it...

 

[RB Smissaert]

Any suggestions where this could be used with any advantage?

RBS

 

[Akihito Yamashiro]

Thank you for your interest in my post.
The two main advantages of the methods introduced in this post are the following.
1. The dll, which is written with the cdecl calling convention, can be called.
2. The dll's name can be set dynamically, allowing for the development of programs using plugins.
(The dll's name cannot be set dynamically within a declare function syntax.)

 

[RB Smissaert]

OK, thanks, I can see now what you mean, except can't you call those dll's
from
VB(A) with a normal Declare?
Could you post a simple example showing some code that uses this that is
useful to
users of this forum.

RBS