Hi there, I'm currently using a database that is acting as a Document Management System. It's main function is to tag documents with properties and custom properties.
I have successfuly been able to tag word, excel and powerpoint documents but have run into trouble with PDF files.
It seems I can't write to a pdf's properties from access, however I have been able to do this from excel? Hence to tag a pdf file I have been opening an excel file that has code along the lines of:
' SET ADOBE ACROBAT OBJECTS
Set AcroApp = CreateObject("AcroExch.App")
Set AVDoc = CreateObject("AcroExch.AVDoc")
Call AVDoc.Open(sSourcePath & "\" & sResourceID, "")
Set AVDoc = AcroApp.GetActiveDoc
Set PDDoc = AVDoc.GetPDDoc
' SET DOCUMENT PROPERTIES
PDDoc.SetInfo "Property Name", "Values Saved"
Any ideas how this can be incorporated into Access? For the excel tool to work I have added a reference to PDFMaker.xla
Any help with this would be greatly appreciated, it's fair to say this has been driving me nuts...
I have successfuly been able to tag word, excel and powerpoint documents but have run into trouble with PDF files.
It seems I can't write to a pdf's properties from access, however I have been able to do this from excel? Hence to tag a pdf file I have been opening an excel file that has code along the lines of:
' SET ADOBE ACROBAT OBJECTS
Set AcroApp = CreateObject("AcroExch.App")
Set AVDoc = CreateObject("AcroExch.AVDoc")
Call AVDoc.Open(sSourcePath & "\" & sResourceID, "")
Set AVDoc = AcroApp.GetActiveDoc
Set PDDoc = AVDoc.GetPDDoc
' SET DOCUMENT PROPERTIES
PDDoc.SetInfo "Property Name", "Values Saved"
Any ideas how this can be incorporated into Access? For the excel tool to work I have added a reference to PDFMaker.xla
Any help with this would be greatly appreciated, it's fair to say this has been driving me nuts...