Open MS Publisher

[Eddie Mason]

Hi All,

Can anyone tell me how to open a Microsoft Publisher document by code from inside an Access 2000 application?

Regards

Eddie

 

[jeremie_ingram]

cREATE A BATCH FILE AND THEN OPEN IT AS AN APPLICATION WITHT HE FOLLOWING CODE.


Private Sub CMDBUTTONNAME_Click()
On Error GoTo Err_CMDBUTTONNAME_Click

Dim stAppName As String

stAppName = "D:\OPENIT.BAT "
Call Shell(stAppName, 1)

Exit_CMDBUTTONNAME_Click:
Exit Sub

Err_CMDBUTTONNAME_Click:
MsgBox Err.Description
Resume Exit_CMDBUTTONNAME_Click

End Sub

Now create the batch file


OPENIT.BAT
@ECHO OFF
"C:\WINDOWS\MY DOCUMENTS\THEDOCUMENT.PUB"

 

[Eddie Mason]

Hi Jeremie,

Thanks for your help.

Regards

Eddie