Functions and String variables

Hi Lukas, thanks for your query. Two things suggest themselves here. First, you can pass an object to another subroutine or function, alter it, and if you are using ByRef, it will update back in your original subroutine. This is, for example, how you build recursive code for, say, looping through however many folders and subfolders you might have.

Secondly, you could of course go all the way and concatenate together an entire text file of code strings, then import that into your project as a new module and call the new functions.

http://www.exceltip.com/show_tip/Modules ,_Class_Modules_in_VBA/Insert_a_new_module_from_a_file_using_VBA_in_Microsoft_Excel/507.html

What you'll end up with is code that writes code....

Hope this helps,

Anthony