1 2 Previous Next 19 Replies Latest reply: Jun 25, 2013 11:08 PM by SaiSandeepT

Client_host cmd problem

DejanH Nov 24, 2008 4:06 AM

Hello.
I want to open excel file on client. File is on another computer. I open the file with clien_host and cmd. The problem is, that cmd window stays opened.

I open file like:
CLIENT_HOST('cmd /c ' || LC$Target);
LC$Target is like //Linux_comp/dir/file.xls.

If i run this, excel starts but the cmd window stays on. When i close excel, cmd closes.

How can i solve this problem?

If i run file like
CLIENT_HOST('cmd /c start c:\Dir\Dir\Excel.exe ' || LC$Target);

cmd window closes after excel is started.

Why is that?
I need 1st version, because not every user has the same excel path.

Any help?

Thanks.

1. Re: Client_host cmd problem

Tony Garabedian Nov 24, 2008 4:23 AM (in response to DejanH)

Try to pass NO_SCREEN parameter as the last parameter of CLIENT_HOST, it should do the trick.
You can also call the excel.exe directly and pass the filename without opening CMD session.

Try it.

Tony
Like Show 0 Likes (0)

Actions
2. Re: Client_host cmd problem

DejanH Nov 24, 2008 4:47 AM (in response to Tony Garabedian)

If I call excel directly it works, but this won't work on computers with openoffice.

That is why i want to open file like this:
CLIENT_HOST('cmd /c ' || LC$Target);
LC$Target is //Linux_comp/dir/file.xls.
Like Show 0 Likes (0)

Actions
3. Re: Client_host cmd problem

Tony Garabedian Nov 24, 2008 6:11 AM (in response to DejanH)

Have you used NO_SCREEN parameter? that should remove the CMD session screen.

Tony
Like Show 0 Likes (0)

Actions
4. Re: Client_host cmd problem

DejanH Nov 24, 2008 6:34 AM (in response to Tony Garabedian)

NO_SCREEN doesn't do anything.
Like Show 0 Likes (0)

Actions
5. Re: Client_host cmd problem

DejanH Nov 24, 2008 7:35 AM (in response to Tony Garabedian)

Solved the problem.

Thanks.
Like Show 0 Likes (0)

Actions
6. Re: Client_host cmd problem

Tony Garabedian Nov 24, 2008 8:04 AM (in response to DejanH)

Please post the solution, so other people with the same problem can see it when they search the forum.

Tony
Like Show 0 Likes (0)

Actions
7. Re: Client_host cmd problem

665887 Nov 24, 2008 8:14 AM (in response to DejanH)

I think
CLIENT_HOST will not open a file from the network/File is on another computer.

Try to open the file by START->RUN->cmd command to open a file before use it in CLIENT_HOST.

Edited by: Balaji.M on Nov 24, 2008 7:44 PM
Like Show 0 Likes (0)

Actions
8. Re: Client_host cmd problem

DejanH Nov 24, 2008 11:40 PM (in response to Tony Garabedian)

This is my solution:
CLIENT_HOST('cmd /c start "" "' || LC$Target ||'"');
Like Show 0 Likes (0)

Actions
9. solved

Nemises Apr 21, 2011 6:28 AM (in response to DejanH)

Im Trying To Run The following Command 'DIR E:\TEST \>E:\TEST\FARAZ.TXT' using client_Host
but Not being able to execute this
when going through debug the problem is not being detected

Edited by: Nemises on Apr 21, 2011 4:28 PM
Like Show 0 Likes (0)

Actions
10. Re: Client_host cmd problem

Amatu Allah Neveen Ebrahim Jan 26, 2011 4:19 AM (in response to DejanH)

DejanH wrote:
This is my solution:
CLIENT_HOST('cmd /c start "" "' || LC$Target ||'"');
So pls mark it Correct or change the title to Solved...!

Regards,

Abdetu
Like Show 0 Likes (0)

Actions
11. Re: solved

894837 Oct 17, 2011 9:48 AM (in response to Nemises)

Hi I tried using the code given by you. But still the cmd prompt is displaying for a second and closing. Can we avoid displaying the command prompt.
Like Show 0 Likes (0)

Actions
12. Re: solved

SaiSandeepT Jun 25, 2013 3:29 AM (in response to 894837)

hi ,check this....
client_host( ' cmd /c start "cmd" "edit" "/r" "E:\TEST\FARAZ.TXT" ' ) ;

thanks....
Like Show 1 Like (1)

Actions
13. Re: Client_host cmd problem

François Degrelle Jun 25, 2013 4:00 AM (in response to DejanH)

Hello,

with the START() command, there is no need to indicates the path to the program (excel.exe). Just put the file name (.xls) and windows will start the associated programe for you.

Francois
Like Show 0 Likes (0)

Actions
14. Re: solved

Shabeer Jun 25, 2013 4:02 AM (in response to SaiSandeepT)

Absolutely, this is correct solution...cheers SaISandeepT
Like Show 0 Likes (0)

Actions

1 2 Previous Next

Go to original post