Skip to content

Instantly share code, notes, and snippets.

xfirebg

Block or report user

Report or block xfirebg

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@xfirebg
xfirebg / ConvertXLS.ps1
Last active Mar 28, 2019 — forked from gabceb/ConvertXLS.ps1
Powershell script to convert all .xls documents to .xlsx in a folder and delete the old one(full auto)
View ConvertXLS.ps1
$xlFixedFormat = [Microsoft.Office.Interop.Excel.XlFileFormat]::xlOpenXMLWorkbook
write-host $xlFixedFormat
$excel = New-Object -ComObject excel.application
$excel.visible = $false
$folderpath = "D:\Users\Username\Desktop\test"
$filetype ="*xls"
Get-ChildItem -Path $folderpath -Include $filetype -recurse |
ForEach-Object `
{
$path = ($_.fullname).substring(0, ($_.FullName).lastindexOf("."))
You can’t perform that action at this time.