ANmarS - Search results

Excel/VBA expert since Sep 1997 (21 years 2 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

1 Q & A posts tagged with primopdf

Tue
Apr 6
2010

What is the VBA code for Convert Excel Worksheet in to PDF in the Name of the Text of specified Cell?

Please Mention the VBA code to convert Excel work sheet in to PDF in the name specified in the particular cell of the Excel Sheet.


Answer

I am assuming you do know how to play around with VBA
In this case, install this PDF Printer
http://www.primopdf.com/

Then print the Excel file through VBA (Record macro and see how it does it)
Then use this VBA line to rename the exported file
Rename [originfilename.ext] AS [newfilename.ext]
Or
Save the file itself (Excel file) with that name from cell, then do the export

PrimoPDF usually saves the file in the same name as the Excel file

Good luck

VBAXLMan http://blog.soliddocuments.com/2010/01/b…

Tuesday 4/6/2010 7:34:07 AM

Tags

History