Help with Acrobat.AVDoc

[jbum]

I have been able to read/write to a PDF using VBA from Excel but I am unable to save or exit the active PDF doc?

I finish the code with:
Acrobat.AVDoc (name).Exit, but it stays open and does not save?

Should I be using PDDoc instead of AVDoc or both?

I am new to both this forum and vba so forgive me if I am in the wrong place.

[TMS]

I didn't even know you could use VBA with Adobe Acrobat files.

Suggest you Google: excel vba adobe acrobat. A lot of stuff comes up but I don't know what is relevant to your scenario.

Regards, TMS

[jbum]

I may not be asking the question right please forgive me if that is the case. here is the code I am using.

Sub WriteToAdobeFields()

Dim AcrobatApplication As Acrobat.CAcroApp
Dim AcrobatDocument As Acrobat.CAcroAVDoc
Dim fcount As Long
Dim sFieldName As String
Set AcrobatApplication = CreateObject("AcroExch.App")
Set AcrobatDocument = CreateObject("AcroExch.AVDoc")

If AcrobatDocument.Open("C:\Documents and Settings\Owner\Desktop\Ticket1.pdf", "") Then
AcrobatApplication.Show
Set AcroForm = CreateObject("AFormAut.App")
Set Fields = AcroForm.Fields
fcount = Fields.Count
Fields("Contact Name").Value = "Mr Customer6897687979679!!!"
Fields("Cust Training").Value = "No"
Fields("Tech Name").Value = "Name"

Else: MsgBox "failure"
End If

' -------------------------------------------- This seems to do nothing
' -------------------------------------------- If I AcrobatApplication.Close it gives me a left side function error
AcrobatApplication.Exit
Set AcrobatApplication = Nothing
Set AcrobatDocument = Nothing
Set Field = Nothing
Set Fields = Nothing
Set AcroForm = Nothing

End Sub

[Norie]

Have you tried Quit instead of Exit?

Also, have you tried Close with the document?

[jbum]

Have you tried Quit instead of Exit?

Also, have you tried Close with the document?

Yes If I use AcrobatApplication.Close it gives me a left side function error.

[Norie]

Close with the document, not the application.

[jbum]

Close with the document, not the application.

Thanks yes I can get it to close, now to get is to save the changes?

[Norie]

Here's a crazy idea, try Save.

PS Here's a couple of links you might find useful.

http://www.khk.net/wordpress/2009/03...-introduction/

http://livedocs.adobe.com/acrobat_sd...yer/PDDoc.html