Exportasfixedformat Vba Excel. Is there a way to print via vba and not get such a large file. Sub loopsheetssaveaspdf create variables dim ws as worksheet loop through all worksheets and save as individual pdf in same folder as the excel file for each ws in activeworkbook worksheets ws exportasfixedformat type xltypepdf filename thisworkbook path ws name pdf next end sub.
You can include a full path or microsoft excel saves the file in the current folder. 2 minutes to read. The exportasfixedformat method is used to publish a workbook to either the pdf or xps format.
The exportasfixedformat method is used to publish a workbook to either the pdf or xps format.
The file name of the file to be saved. The exportasfixedformat method is used to publish a workbook to either the pdf or xps format. Workbook exportasfixedformat method excel 05 29 2019. When i printed a worksheet to pdf using file print i get a file that is 344kb in size.
