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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie
Dim iLastRow As Long Dim i As Long Dim sTemp As String iLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To iLastRow sTemp = sTemp & "sp_addexternlogin ""," & Cells(i, "A").Value & _ ",""," & " trust_user , trustuser" & vbNewLine & _ "go" & vbNewLine Next i MsgBox sTemp -- HTH RP (remove nothere from the email address if mailing direct) "kenworld" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Newbie
Thanks for your response, I'll give this a shot. Kenworl -- kenworl ----------------------------------------------------------------------- kenworld's Profile: http://www.excelforum.com/member.php...fo&userid=2454 View this thread: http://www.excelforum.com/showthread.php?threadid=38137 |
Reply |
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 |