ShellExecute

[driessen]

Hello,

I want to open a Word document without using OLE.
But I also want a macro to be executed.

Normally for opening a document and executing a macro MACRO you do :

WINWORD.EXE LETTER.DOC /MMACRO

Because I don't know the exact path of WINWORD.EXE, I want to use ShellExecute()

So I tried this code :

Code: Select all  Expand view

ShellExecute(,"Open","LETTER.DOC","/MMACRO",,3)

The document is opened in Word, but the macro MACRO is not executed, although the 4th position is ment to add parameters.

What can I do to execute the macro in an automatic way ?

Thanks a lot in advance for any help.

[Jack]

Michel,

Try with winexec .

lnf:="i:\Ret"+dtos(date())+substr(time(),1,2)+"h"+substr(time(),4,2)+".doc"
WinExec( "winword " + lnf )

Good luck .

Ph Jacquet (Belgium)

[Antonio Linares]

Michel,

Have you tried with "//MMACRO" ? (notice the two //)

[driessen]

Antonio,

You are the greatest. The double backslash was the right solution.

(After EDIT : Sorry, the problem is not solved - see my new message)

Thank you very much.

To Philippe,

I also tried your WINEXEC proposal, but it doesn't work.

But thank you for your effort.

[anserkk]

Hi,
Can anybody explain, What is the difference between ShellExecute() and WinExec(). Is there any performance difference between the two ?

Regards
Anser

[driessen]

Sorry, Antonio, the problem was not solved.

the double backslash doesn't seem to be a solution.

Anyone any idea ?

Thanks.

[Patrizio]

Driessen, http://msdn.microsoft.com/en-us/library/bb762153(VS.85).aspx

lpParameters
[in] If lpFile specifies an executable file, this parameter is a pointer to a null-terminated string that specifies the parameters to be passed to the application. The format of this string is determined by the verb that is to be invoked. If lpFile specifies a document file, lpParameters should be NULL.

So, you can't pass parameter if you open a .doc.

But, if you open a exe you can, try this

Code: Select all  Expand view

shellexecute(,"open","winword.exe","LETTER.DOC /MMACRO")

[driessen]

Patrizio,

Thank you very much for your help.

Your suggestion is working fine. My problem is solved.

Thank you, guys.