ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Recording a macro within existing macro. (https://www.excelbanter.com/excel-programming/322775-recording-macro-within-existing-macro.html)

BBQDad[_2_]

Recording a macro within existing macro.
 
Let us assume that we have some existing VBA code we have either written or
recorded.

Now, we want to record some actions (generate additional code) at a specific
point in the existing code.

Can this be accomplished in any way other than recording a new macro and
then cutting and pasting the newly generated code into the existing code?

I apologize if this is off-topic; it seems to be more closely related to
programming than to anything else.

Thanks in advance for your advice.
--- BBQDad

Don Guillett[_4_]

Recording a macro within existing macro.
 
It seems, for you, that may be the best approach. Or you could just call the
new macro
sub doit()
beginning of code
call newcode
rest of code
end sub

--
Don Guillett
SalesAid Software

"BBQDad" wrote in message
...
Let us assume that we have some existing VBA code we have either written

or
recorded.

Now, we want to record some actions (generate additional code) at a

specific
point in the existing code.

Can this be accomplished in any way other than recording a new macro and
then cutting and pasting the newly generated code into the existing code?

I apologize if this is off-topic; it seems to be more closely related to
programming than to anything else.

Thanks in advance for your advice.
--- BBQDad




Jim Thomlinson[_3_]

Recording a macro within existing macro.
 
Nope... Just cut and paste...

"BBQDad" wrote:

Let us assume that we have some existing VBA code we have either written or
recorded.

Now, we want to record some actions (generate additional code) at a specific
point in the existing code.

Can this be accomplished in any way other than recording a new macro and
then cutting and pasting the newly generated code into the existing code?

I apologize if this is off-topic; it seems to be more closely related to
programming than to anything else.

Thanks in advance for your advice.
--- BBQDad



All times are GMT +1. The time now is 04:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com