Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
line breaks in a variable
IO currently have the following variable in one continuous line:
sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000. VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) (STATISTICS) /STATISTICS mean( ( F7.2 ))." The program I am passing the variable sTables to needs sTables to look exactly like: sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000. VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) (STATISTICS) /STATISTICS mean( ( F7.2 ))." so that there is a line break after each period mark. I cannot figure out how to create line breaks within the parentheses? Lance |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
line breaks in a variable
sTable = Application.Substitute(sTable,".", vbNewLine & ".")
you might also try vbCr or vbLf in place of vbNewline (vbNewline is equivalent to vbCRLF in windows). Regards, Tom Ogilvy wrote in message ... IO currently have the following variable in one continuous line: sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000. VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) (STATISTICS) /STATISTICS mean( ( F7.2 ))." The program I am passing the variable sTables to needs sTables to look exactly like: sTables = "* Basic Tables. TEMPORARY. NUMERIC T0000000. LEAVE T0000000. VARIABLE LABEL T0000000 'Table Total'. VALUE LABELS T0000000 0 ' '. TABLES /FORMAT BLANK MISSING('.') /OBSERVATION " & myVars4ANOVA & " /TABLES (" & myVars4Table & ") BY (" & Groupvar & "+ T0000000) (STATISTICS) /STATISTICS mean( ( F7.2 ))." so that there is a line break after each period mark. I cannot figure out how to create line breaks within the parentheses? Lance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line breaks in Excel | Excel Discussion (Misc queries) | |||
Line breaks | Excel Discussion (Misc queries) | |||
unexpected line breaks in .csv | Excel Discussion (Misc queries) | |||
manual line breaks | Excel Discussion (Misc queries) | |||
Line breaks | Excel Worksheet Functions |