0

I have an automatically generated report which displays a number of fields from a single record of a query. The end goal is actually to automate the exportation of this report to a PDF file, so that other users can automatically generate PDF files from an Access 2007 form.

There is a common solution that use DoCmd.OutputTo and acFormatPDF, but this requires the user to have the add-in which allows saving to PDFs in Office 2007 applications. By default, my end user will not have this add-in installed and I do not think I can rely on them ever having it installed.

Is there another way to get to a PDF, which doesn't involve additional add-ins or applications?

Community
  • 1
  • 1
Fritz
  • 624
  • 1
  • 7
  • 14
  • Why do you need an add-in? PDF support is baked in to Office 2007 – Alex K. Apr 04 '16 at 15:24
  • @AlexK. - No, it isn't. http://new.office-watch.com/2010/saving-to-pdf-in-access-2007/ – Fritz Apr 04 '16 at 15:35
  • 1
    If no add-ins or other installs are allowed then you can't do this with Office 2007 – Tim Williams Apr 04 '16 at 15:59
  • "Save to PDF" capability was included with Office 2007 Service Pack 1. Are your users actually running Office 2007 applications without having installed the official service packs? – HansUp Apr 04 '16 at 16:38
  • @HansUp Yeah... Local machines have the service pack, but all remote desktop users do not have it. – Fritz Apr 04 '16 at 17:59

1 Answers1

0

Have you tried the ExportAsFixedFormat method? e.g. ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF FileName:=“sales.pdf” Quality:=xlQualityStandard DisplayFileAfterPublish:=True https://msdn.microsoft.com/en-us/library/bb238907%28v=office.12%29.aspx

Absinthe
  • 3,258
  • 6
  • 31
  • 70