Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie
Anyone, I'm trying to create a macro to automatic a tedious task. I need help with a macro to concentatenate a string. For example, I have a list of usercodes: Column A nx109 px205 px206 qx123 I want to add the usercodes to a string that reads like this. sp_addexternlogin SQL_PROD, wr_",nx109,", trust_user , trustuser" go sp_addexternlogin SQL_PROD, wr_",px205,", trust_user , trustuser" go sp_addexternlogin SQL_PROD, wr_",px206,", trust_user , trustuser" go sp_addexternlogin SQL_PROD, wr_",qx123,", trust_user , trustuser" go Please Help Kenworld -- kenworld ------------------------------------------------------------------------ kenworld's Profile: http://www.excelforum.com/member.php...o&userid=24543 View this thread: http://www.excelforum.com/showthread...hreadid=381377 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Real Newbie newbie question | New Users to Excel | |||
Help for a newbie? | Excel Worksheet Functions | |||
JET dB Newbie Needs Help | Excel Discussion (Misc queries) | |||
Newbie needs help in VBA | Excel Programming | |||
Newbie needs help | Excel Programming |