Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Malimerge call from VFP
Message
From
30/06/2010 09:03:50
 
 
To
29/06/2010 20:58:29
Hong Yew
People Quest
Malaysia
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01471034
Message ID:
01471062
Views:
73
>Hi all
>
>My VFP9 call Word with following code
>
> DECLARE INTEGER ShellExecute IN Shell32.DLL INTEGER hwnd, ;
> STRING @lpOperation, STRING @lpFile, STRING @lpParameters, ;
> STRING @lpDirectory, INTEGER nShowCmd
> lcParms = ""
> lcDir = addbs(toApplication.ProjectDirectory)+'DOCS'
> lcFile = alltrim(juststem(tcOutputFileName))+'.DOC'
> lcOp = 'open'
> lnshow = 3
> lnError = ShellExecute(0, @lcop, @lcfile, @lcparms, @lcdir, lnshow)
>
>MS Word will prompt following
>
> Opening this documet will run following SQL command:.
> ...........
> Data from your database will be placed in the docuemnt. Do you want to continue?
>
>which I have to click Yes. Is there a way to bypass this prompt and goto Word directly?
>

Have you tried using Automation instead of ShellExecute to see whether you can get the control you need?

Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform