ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Wrap a command line string (https://www.excelbanter.com/excel-programming/329417-wrap-command-line-string.html)

Stuart[_21_]

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.



Paul Martin

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


Stuart[_21_]

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




Paul Martin

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.


Paul Martin

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



All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com