If you know the excel VBA based solution to this, can you please share the VBA code or link to a page. I tried VBA method listed at -- Ref 2 Methods to Quickly Save Each Excel Worksheet as a Separate PDF File - Data Recovery Blog. However, that meets with division by zero error. I updated the code to include the FileName using code at (ref. -forums/excel-general/17536-vba-for-current-excelfile-filenam... ) in the first line of the command to accomplish what I need.