Call a function dynamicly

[swatty]

I want to call a function according the value of a combobox

Let's say my combo is filled with
"code39"
"code41"
"code52"
"code53"

Now i want to execute the function related to the chosen comboitem

Function names are

make_file_code39
make_file_code41
make_file_code52
make_file_code53

tried it with "make_file_" & cmbCode.Value

no luck till now.

[techgnome]

Look into the CallFunctionByName (or CallMEthodByName, or CallByName -- something like that) statement, it should be of help.

[swatty]

The callbymname needs a object where this function resides.

My functions aren't in a class or member of any other object.

Therefore this will not work (tried it already)

[Michael_Kamen]

You're saying your functions aren't anywhere?

[swatty]

I don't say what you think i am saying


The callbyname function can be used to call functions from objects , objects are classes , a form is also a class.

a simple module isn't a class and therefore can't be used here.

I will have several modules with the code in it to generate files according the type selected in the combo.

I think i will need to use a select case statement to work around this issue;

The whole meaning of calling it dynamicly was , when i add a module to the .mdb (access) i didn't need to add an extra case statement to the code, guess it will be the only way to do it.

[Michael_Kamen]

http://www.vbforums.com/showthread.p...ght=callbyname

Take a look at the last post.....

[Harle]

tried it with "make_file_" & cmbCode.Value

shouldn't it be:
tried it with "make_file_" & cmbCode.Text

My brain hurts from too many loops and arrays so I could be wrong.

[swatty]

Originally posted by Michael_Kamen
http://www.vbforums.com/showthread.p...ght=callbyname

Take a look at the last post.....

Been trying this whole day,
one error i cant get around
Error number 2465
description "Application-defined or object-defined error"

Which object must be specified in it, the functions will be in different code modules ????

[swatty]

Got to take some evening course , will check again tommorrow.

[Wokawidget]

Instead of having these functions in a module, crate a class module with them in instead...this will make things SO much easier

Woka

[MartinLiss]

swatty: The code that Michael_Kamen pointed out to you is mine. Can I help? What line is giving you that error, and is it from my code or a modificatiion?

[Wokawidget]

The methods are in a module, which can't be passed, as the object, to the CallByName function
Personally I would add them to a class module, as this would solve loads of problems.

Woka

[swatty]

Marty , the error occures on the line where the call is made.
The code has been modified, but in the other reply you stated it could be called from a code module also.

It doesn't work for me and i think this can't be done that way.

Woka the class isn't an option. I only need to have functions in different modules to be called refering the item chosen in a combo.

[Wokawidget]

I am at a loss then
Wonder if you could do something with CopyMemory API...Hmmmm

Woka

[MartinLiss]

Originally posted by swatty
Marty , the error occures on the line where the call is made.
The code has been modified, but in the other reply you stated it could be called from a code module also.

It doesn't work for me and i think this can't be done that way.

Sorry but it looks like you are correct. The called procedures either need to be in the form or a class.

[swatty]

So I may assume your previous answer was not totally correct.

No worries , i'll use a select case then and and a case for each new module created.

Thanks anyway for the reply.