Forum Discussion
Mail Excel Sheets as PDF
I have this VBA however i want the emails to be sent as PDF and not Excel Sheets and can't change the File Format to PDF . Is there an extra line to be added I tried changing XFile EXT to PDF but tha...
Joanne_Neville1970 A quick search in this forum for save PDF finds posts such as Saving worksheet as pdf with worksheet name and date stamp. The first two such posts that I read both used the ExportAsFixedFormat method of the Worksheet object to create a PDF, rather than the SaveAs method of the Workbook object. (A method of that same name is also available for the Workbook object, if you should need to use that.)