C
Chris
I'm trying to execute a small C program from an excel vba module. The
C program is an executable that I've compiled that takes in 6
parameters, 3 of the parameters are full length path names.
My entire variable is
tmp = cropCommand & convertFPath & " " & cropPath & " " &
Str(cropArr(1)) & " " & Str(cropArr(2)) & " " & Str(cropArr(4) -
cropArr(2)) & " " & Str(cropArr(3) - cropArr(1))
Shell(tmp)
as you can imagine this is a rather long string
cropCommand, convertFPath, and cropPath all have the general string
length of
"Z:\tmp\user_name1\folder\longerFolderName\Doc\excel\images
\executable.exe" so concatenating this 3 times is rather long.
When I add a watch on the resulting tmp variable after all the
concatenations it only gets up to the last few characters of cropPath
and the last 4 numbers aren't added.
C program is an executable that I've compiled that takes in 6
parameters, 3 of the parameters are full length path names.
My entire variable is
tmp = cropCommand & convertFPath & " " & cropPath & " " &
Str(cropArr(1)) & " " & Str(cropArr(2)) & " " & Str(cropArr(4) -
cropArr(2)) & " " & Str(cropArr(3) - cropArr(1))
Shell(tmp)
as you can imagine this is a rather long string
cropCommand, convertFPath, and cropPath all have the general string
length of
"Z:\tmp\user_name1\folder\longerFolderName\Doc\excel\images
\executable.exe" so concatenating this 3 times is rather long.
When I add a watch on the resulting tmp variable after all the
concatenations it only gets up to the last few characters of cropPath
and the last 4 numbers aren't added.