I have an Excel file that executes codes to find data based on user-defined criteria. This file will be copied by 8 other groups and all 9 copies will be used for their group's specific user-defined criteria. I'm hoping to move my code into an external document so I can have a single source of code for all 9 files. Is there a code I can put in Excel that opens and executes a code document? If not, then any other suggestions?


Also, I can only use Notepad++ (company policy). I've been programming in VBA but I (vaguely) know Perl, which some people say works better for opening external documents.

Thanks!!



(P.S. I noticed an older thread that had a similar question but the person never responded back so I don't know if the suggestion worked.)