How Do I create a Sendkey Code?

[HazatB]

Hello All,

I am attempting to create a Macro that updates the naming convention in a specific application. In this Macro I will have 1 column that lists account names starting with T001 and goes all the way to T100, in the application I will be using all accounts should be listed in the same format going from T001 to T100. What I am attempting to do is to go run a macro that adds _Law. This would alter the name within the application to say T001_Law to T100_Law. Could anyone assist with starting off this SendKey Code.

 

[jkpieterse]

No need for SENDKEYS I expect. What -precisely- is the intention; do you need the macro to do a search and replace in the entire workbook for all those strings?

 

[HazatB]

I need the macro to update the workbook to add _Law and then copy + paste to a non excel application.

 

[HazatB]

Any help?