Generate PDF Report Using Excel VBA

[annpricks]

Hi All,

I need to generate PDF report using excel vba. That PDF report contains the table.

1) Need to create a table in PDF file using VBA
2) Need to convert excel file to PDF
3) Paste the values into appropriate columns in PDF table.


Can anyone Please tell me how to do this?

Any help needs to be appreciated


Thanks
Ann

[stojko89]

You didn't give us much info to work around with.
If you can then post an example workbook of what you want put in the pdf and how it should look like
Also why wouldn't you make an excel file and then just save it as a pdf so you don't code what to put where in the pdf file?
I think it's an easyer way it's what I'm doing