I have a script that gathers PC information, then (is supposed to) displays the info it gathered in an Excel spreadsheet, but I can't get the script to open the file. I've tried hardcoding the filename, but the best I get is an empty Excel window to open.
I have not dealt with Excel and PS, so I could use some help. Here is what I have so far:
function Show-RefreshData ($refreshdata)
{
$schemaFinal = create-schemaFinal $refreshdata
$date = Get-Date -Format MM.dd.yyy.hh.mm.ss
#$filename = ".\Output\RefreshData_Test.xlsx"
$refreshdata | select-object $schemaFinal | Export-XLSX -Path ".\Output\RefreshData_$(Get-Date -Format dd.mm.yy.hh.mm.ss).xlsx"
$excelDoc = New-Object -ComObject excel.application
#$excelDoc.ClearSheet()
$excelDoc.visible = $true
$excelDoc.workbooks.Add()
#$workbook = $excelDoc.Workbooks.Open($filename)
}
The last line is commented out because I'm not sure how to reference the same file created with the Get-Date cmdlet. I know I'm close. I just need a little hint. The data gets pulled from a SQLite db, btw.
