open_multiple_excel_sheets.ps1

# Create a new Excel Application object
$excelApp = New-Object -ComObject Excel.Application

# Set visibility to true (to make Excel visible)
$excelApp.Visible = $true

# Get a list of all Excel files in the current folder
$excelFiles = Get-ChildItem -Path . -Filter *.xlsx

# Loop through the list and open each Excel file
foreach ($file in $excelFiles) {
    $workbook = $excelApp.Workbooks.Open($file.FullName)
}

# When you're done, you can close Excel
#$excelApp.Quit()