Rhys_m_jones
New Member
I am struggling to find a way to run a macro from one open workbook on another open workbook, which are both in the same handle. I am consistently greeted with an exception thrown up by the "code stage".
Steps:
1. Create Excel Instance
2. Show Instance
3. Open File
4. Open Template (where the macro is stored).
5. Activate File
6. Run Macro
The macro itself is relatively easy data manipulation, but unfeasible to do within BP.
Does anybody have any experience of this and/or found a workaround?
Many thanks.
Steps:
1. Create Excel Instance
2. Show Instance
3. Open File
4. Open Template (where the macro is stored).
5. Activate File
6. Run Macro
The macro itself is relatively easy data manipulation, but unfeasible to do within BP.
Does anybody have any experience of this and/or found a workaround?
Many thanks.