generate PDF using VBA

Question

I want to generate a PDF file using VBA, I found some tools but I am not sure if it supports to generate in a table format. Or is there another third party tool(free) to generate an access form in PDF format?

Answer 1

Depending on what you want to export and what VBA application you are using you have a few options.

If you are exporting an access report then this is good (and free!) http://www.lebans.com/reporttopdf.htm

For most other things you can use a PDF print driver and push anything you want to export to the “printer”. There are a number of free and commercial options here so google is your friend