Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrap a command line string
I have: Shell Path & Command
where Command starts with an executable and continues with a string of switches/options. Something like Command = "Execute .....a rather long string...." The result is a long statement. To make it more readable and understandable, I've tried splitting the string with "_" but this causes errors. Am I using the underscore incorrectly, or is there a better way, please? Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrap a command line string
Hi Stuart
Do you have a space before the underscore, ie " _". To spread a string over more than one line, it would look something like this: "Some text here" & _ "Some more text here" & _ "Yet more text" Regards Paul Martin Melbourne, Australia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrap a command line string
Thanks, am doing that.
Will investigate further. Regards. "Paul Martin" wrote in message oups.com... Hi Stuart Do you have a space before the underscore, ie " _". To spread a string over more than one line, it would look something like this: "Some text here" & _ "Some more text here" & _ "Yet more text" Regards Paul Martin Melbourne, Australia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrap a command line string
Try submitting some of the code so we can see what you need to do to
get it to work. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wrap a command line string
Stuart
I once had a persistent error with the Shell command, and it turned out that the argument after Path needed quotation marks - Chr(34) - around it. What errors are you getting? Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
String-in-Cell .... too long??? Word Wrap not working...PLEASE HE | Excel Discussion (Misc queries) | |||
Does Excel 2003 have a shortcut command to wrap text in a cell? | Excel Discussion (Misc queries) | |||
Is there a Wrap Text command button? | Excel Discussion (Misc queries) | |||
Reads entire *.txt file into string opposed to a desired line by line input. | Excel Programming | |||
Execute a command line app but i want a string returned. | Excel Programming |