Shell printing and close 1

[royalcheese]

I have this code

retval = Shell("c:\program files\microsoft office\office11\winword.exe T:\EAD\Letters\Receipt_address_change.doc")

This opens up me file, but , i want to print and close it after this and not let the user print.

Thanks in advance ,

chris

 

[pmb55]

Check out this page on the Microsoft Support site...

http://support.microsoft.com/?kbid=210030

This may get you what you need.

Philip

 

[pmb55]

The shell process will only initially execute the application (in this case, Word). You will need to open the Word application as an object in your VB app so that you can perform the print and close functions. The example used in the reply above from the Microsoft KB is an MSAccess / MSWord process, but the coding is the same for your app.

Philip

 

[RoyVidar]

Then there's also the ShellExecute API.

[tt]' declaration section
Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _
(ByVal hwnd As Long, ByVal lpOperation As String, _
ByVal lpFile As String, ByVal lpParameters As String, _
ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long

' then in a sub
ShellExecute hwnd, "Print", "T:\EAD\Letters\Receipt_address_change.doc", _
vbNullString, vbNullString, 0[/tt]

Roy-Vidar

 

[royalcheese]

Roy , perfect

Happy easter

Chris