Macro to install code into another workbook

[fullysic]

Hi guys,

I have a question on how I would create a macro to install code in another workbook.

Essentially I want to do two things: Copy (or install) a module with code into a selected workbook, and also modify an existing part of a macro in the selected workbook. The process flow would be similar to the below:

• User is presented with a list of all open workbooks and clicks desired workbook they want to install additional code into
• Macro automatically copies a module from the current workbook to the selected workbook
• User is then presented with a list of all macros in the selected workbook and clicks the desired macro to install this code in.
• Once selected, macro looks for a specific line of code in that subroutine, eg TO:, and replaces it with a predefined value.

I am getting better at VBA, but unfortunately this is over my head. I know some of it is possible from what I've read, and would love an expert to take a look at tell me if it's possible. Any help would be much appreciated.

Many thanks,
fullysic

[fullysic]

Just an update on where I'm at with this -

I've managed to create a form with a combobox that lists all open workbooks, and once the desired workbook is selected my new code module is copied into this selected workbook.

However, I'm currently stuck with creating another form with a combobox to list all macros in this open workbook, and once the macro is selected code is inserted into this module at the top under any variable declarations.

I'll keep working on it, but if anyone has any tips on the above please let me know.

[fullysic]

Another update:

I've figured out how to add custom code to a module, however I am unable to ensure it is added to a specific subroutine.

The code I'm using to add to a module is :

Please Login or Register  to view this content.

Now realistically, I don't want to specify the module that the sub is in, but rather supply the sub name itself and have the code inserted. Is this possible at all?