Friday, January 13, 2012

Excel-VBA to Export Excel Data into PDF File

!.....VBA program to Export (Activeworkbook & Activesheet) data into PDF File....!

Sub Export_to_PDF()
ActiveSheet.ExportAsFixedFormat xlTypePDF, "d:\abc1.pdf"
ActiveWorkbook.ExportAsFixedFormat xlTypePDF, "d:\abc2.pdf"
End Sub

No comments:

Post a Comment

Excel VBA to send email from excel with HTML table in a email body

'' Excel vba script to send email from outlook & email body in HTML table format. ''Write down email body in HTML tags...