Shellexecute problem.

[hag]

Trying to open a prn file in excel using the following code.

Code: Select all  Expand view

local cfile   := ":\"   
local cName   := Curdir()      
local cDri    := curDrive()   

cFile := cDri+cFile+cName      

ShellExecute( 0,"Open","Excel", "BSfile.prn","cFile",9)

The BSfile.prn is created in my program.

It opens two Excel files.
1 is OK but opens a second copy in read only.

How to fix and get one working.

Thanks in advance.

Harvey

[Rick Lipkin]

Harvy

Try this .. let the local machine figure out what to open the file with .. if it is an .xls .. Excel will be launched ..

Code: Select all  Expand view

SHELLEXECUTE( "", "open", cFILE ,"","",1)


Rick Lipkin

[hag]

Thanks for the quick response.

The file I create is a .prn file not an xls. Need to tell what to open it with.
I did this

Code: Select all  Expand view

shellexecute("","excel",myfile," ",1)
 

Still got two copies.

[Rick Lipkin]

Harvy

you might want to try WaitRun .. here is an example I use for Notepad :

Code: Select all  Expand view

WAITRUN( "NOTEPAD " +cFILENAME, 1 )

It assumes Notepad is in the 'path' to run ..

RIck Lipkin

[hag]

Problem solved.

After reviewing your suggestions, nothing worked. i went through the code and found it was a redundantcy in my code. My fault.