Hello,
I understand your requirement for custom metadata in PDF files saved using Adobe Acrobat's PDF Maker in Excel. I can develop a VBA solution that allows you to enter metadata in designated cells, and upon saving the file as a PDF, this metadata will be automatically applied. While Acrobat is typically required for this task, I'll explore options to minimize dependencies. If not, the alternative approach of modifying existing PDF files using Excel-generated metadata is viable. The metadata fields you specified, including PDF Producer, Application, PDF Version, Created, and Modified, can be seamlessly integrated. I'll ensure a user-friendly solution, and I'm committed to delivering a flexible and efficient tool that meets your specific needs. Looking forward to the opportunity to provide a customized and effective solution for your PDF metadata requirements.
Regards,
Zafar