Calling procedures in code module or another project

[TTThio]

Hi,

could someone let me know how to call procedures located in code/standard module(.bas) or in module of separate project (exp .mdb/.xls)?

I've read about setting reference first of the project if you want to call another project's procedure, but when I go to the reference window, it only has .dll, .ocx, etc. When I do browse and insist of calling the .xls for example, it said it can't reference the object.

I've build a project, and a lot of the procedures are applicable to build another projects. So, instead of rewriting codes, it would be nice just to call the existing ones. I could just export the module as .bas,and import in another project, but I'll need to reimport everytime I make changes in the code module (not automatically updated).

Please help me with this, I could just understand it wrong how the calling/referencing procedures work. But if I'm correct, I greatly appreciate any help to make it work.

Thanks a lot,
Tin Tin

 

[MichaelRed]

This may be substantially different depending on the versoin of whatever program you are using. You should go to the HELP menu for the program you are using, look up "reference" or "references" and print out all that seem even remotely applicable. Read all of the info and go through the examples. It should become somewhat less muddy.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over