Hi all - here's a challenge for ya:
Backgound:
I have a fairly densly packed excel workbook which contains data dumped from our planningsystem.
In this workbook i've made a lot of macros to automate various planning tasks, since the real planning system pretty much sucks, and its faster to dump the data to excel, automated the task and then just import it back into the planning tool..
However, this workbook has caught on, and now the engineering dep wants separate workbooks for each disciplines each week.
So instead of making a separate dump into excel from the planning tool for each discipline, i'd like to only make one dump to my workbook and then have a macro create/set up macros in the workbooks which is created for each discipline.
Problem:
So the question is:
How do i make a macro which creates a macro in another workbook?
Simplified & broken down:
1. Workbook A has a list of data
2. Workbook A has a macro which creates Workbook B and moves the data to this (This macro i already have)
3. Workbook A's macro also creates a macro in workbook B to i.e sort the list (independent of access to workbook A)
Any ideas will be greatly appreciated
cheers,
Ronny
Backgound:
I have a fairly densly packed excel workbook which contains data dumped from our planningsystem.
In this workbook i've made a lot of macros to automate various planning tasks, since the real planning system pretty much sucks, and its faster to dump the data to excel, automated the task and then just import it back into the planning tool..
However, this workbook has caught on, and now the engineering dep wants separate workbooks for each disciplines each week.
So instead of making a separate dump into excel from the planning tool for each discipline, i'd like to only make one dump to my workbook and then have a macro create/set up macros in the workbooks which is created for each discipline.
Problem:
So the question is:
How do i make a macro which creates a macro in another workbook?
Simplified & broken down:
1. Workbook A has a list of data
2. Workbook A has a macro which creates Workbook B and moves the data to this (This macro i already have)
3. Workbook A's macro also creates a macro in workbook B to i.e sort the list (independent of access to workbook A)
Any ideas will be greatly appreciated
cheers,
Ronny