Save a Microsoft Excel Workbook as a PDF File by Using PowerShell

ExportTo-ExcelPDF.ps1

# ref: https://devblogs.microsoft.com/scripting/save-a-microsoft-excel-workbook-as-a-pdf-file-by-using-powershell/
# run as administrator priviledge

$path = Get-Location 
$xlFixedFormat = "Microsoft.Office.Interop.Excel.xlFixedFormatType" -as [type]
$excelFiles = Get-ChildItem -Path $path -include *.xls, *.xlsx -recurse
$objExcel = New-Object -ComObject excel.application
$objExcel.visible = $false
foreach($wb in $excelFiles)
{
 $filepath = Join-Path -Path $path -ChildPath ($wb.BaseName + ".pdf")
 $workbook = $objExcel.workbooks.open($wb.fullname, 3)
 $workbook.Saved = $true
"saving $filepath"
 $workbook.ExportAsFixedFormat($xlFixedFormat::xlTypePDF, $filepath)
 $objExcel.Workbooks.close()
}
$objExcel.Quit()

when i run this code i don't got response, because it's hanging in

$workbook.ExportAsFixedFormat($xlFixedFormat::xlTypePDF, $filepath)

then i have printed the content of '$xlFixedFormat::xlTypePDF'(using "$xlFixedFormat::xlTypePDF saving $filepath"), which is

::xlTypePDF saving C:\\ex1\a.pdf