Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
long text string
Could someone please help me with this.. I am trying to write a simple telephone script....I would use word, bu the script will eventually reference formulas...so i thought excel woul work..... This is what I have....The problem I am having is that I am trying t go to the next line so I can see everything and it is givin errors....i am using the blank space and the _ to go to the next lin and it won't work....Does VBA have word wrap?..... Dim introScript as string Dim clientFirstName as string Dim additionalCash as currency clientFirstName = frmStep3.txtFirstName.value additionCash = frmStep3.txtAdditionalCash.value introScript = "Hi " & clientFirstName & " this is Josh from ABC Co how are you? Based on your information, you are requesting " additionalCash & " is this correct?" ......The script is much longer....is there anyway to put this so i can be on multipe lines in the VBA editor...when i use the blank spac and _ character is gives me errors....Also, does anyone know if ther are any templates for telephone scripts?.... ...thanks for any help Jos -- jhahe ----------------------------------------------------------------------- jhahes's Profile: http://www.excelforum.com/member.php...fo&userid=2359 View this thread: http://www.excelforum.com/showthread.php?threadid=56412 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
long text string
Why dont you store/edit/maintain the strings in Excel cells, and have your code read them from there? insert "placeholders" for your variables.. For each rngRow in rngClientTable.Rows s= Range("introscript").Value s= replace (s,"%clientfirstname%", txtFirstName.Text) s= replace (s,"%additionalcash%", txtAdditionalCash.Text) instroscript=s Capisce? -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam jhahes wrote in Could someone please help me with this.. I am trying to write a simple telephone script....I would use word, but the script will eventually reference formulas...so i thought excel would work..... This is what I have....The problem I am having is that I am trying to go to the next line so I can see everything and it is giving errors....i am using the blank space and the _ to go to the next line and it won't work....Does VBA have word wrap?..... Dim introScript as string Dim clientFirstName as string Dim additionalCash as currency clientFirstName = frmStep3.txtFirstName.value additionCash = frmStep3.txtAdditionalCash.value introScript = "Hi " & clientFirstName & " this is Josh from ABC Co, how are you? Based on your information, you are requesting " & additionalCash & " is this correct?" .....The script is much longer....is there anyway to put this so it can be on multipe lines in the VBA editor...when i use the blank space and _ character is gives me errors....Also, does anyone know if there are any templates for telephone scripts?.... ..thanks for any help Josh |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
long text string
introScript = "Hi " & clientFirstName & " this is Josh from ABC Co, " & _
"how are you? " & vbNewLine & _ "Based on your information, you are requesting " & _ additionalCash & ". Is this correct?" demo'd from the immediate window: clientFirstName = "Jim Bob" additionalCash = "$1,000,000" introScript = "Hi " & clientFirstName & " this is Josh from ABC Co, " & _ "how are you? " & vbNewLine & _ "Based on your information, you are requesting " & _ additionalCash & ". Is this correct?" ? introScript Hi Jim Bob this is Josh from ABC Co, how are you? Based on your information, you are requesting $1,000,000. Is this correct? -- Regards, Tom Ogilvy "jhahes" wrote in message ... Could someone please help me with this.. I am trying to write a simple telephone script....I would use word, but the script will eventually reference formulas...so i thought excel would work..... This is what I have....The problem I am having is that I am trying to go to the next line so I can see everything and it is giving errors....i am using the blank space and the _ to go to the next line and it won't work....Does VBA have word wrap?..... Dim introScript as string Dim clientFirstName as string Dim additionalCash as currency clientFirstName = frmStep3.txtFirstName.value additionCash = frmStep3.txtAdditionalCash.value introScript = "Hi " & clientFirstName & " this is Josh from ABC Co, how are you? Based on your information, you are requesting " & additionalCash & " is this correct?" .....The script is much longer....is there anyway to put this so it can be on multipe lines in the VBA editor...when i use the blank space and _ character is gives me errors....Also, does anyone know if there are any templates for telephone scripts?.... ..thanks for any help Josh -- jhahes ------------------------------------------------------------------------ jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596 View this thread: http://www.excelforum.com/showthread...hreadid=564129 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prevent a long string of text from wrapping in a text fil | Excel Discussion (Misc queries) | |||
Creating a long string of text... | Excel Worksheet Functions | |||
search for date in long string of text | Excel Discussion (Misc queries) | |||
Extract specific value from a long text string | Excel Worksheet Functions | |||
Error: The text string you entered is too long. | Excel Discussion (Misc queries) |