Need Help Generating PDF Paginated Reports from Excel VBA

[CesarF]

Hello everyone,

I'm currently working with data stored in SQL Server and need to generate PDF paginated reports using an Excel VBA macro.
Ideally, I'm looking for a simple and efficient tool (preferably open-source) that can be integrated with VBA to automate the report generation process.

Does anyone have recommendations for libraries, tools, or solutions that can help with this?
Any suggestions or guidance would be greatly appreciated!

Thank you in advance!

 

[Misca]

Try creating the actual report using Power Query and generate the PDF files from the queries with a macro.

 

[CesarF]

Hi @Misca,

Thank you for your input! However, I’m using SQL instead of PowerQuery due to the nature of my data, and there’s no issue with the data itself. I implemented a macro with pagination logic in another report, but I’m not happy with it.

I’m looking for a more efficient or user-friendly solution. Any suggestions?

Thanks again!

Best regards,
Cesar