hello together,  I've got a little problem with a shell I'm writing at the moment and I hope someone of you can give me a hand, cause it is my first script. I tried to get the size of directories into a .txt-file with a batch - no problems 

Today my boss told me, that it would be great to get these informations out of txt into an excel table. I looked around a bit, found the powershell and tryed to write a possible script for this and most functions are working... but excel doesn't save the file... not as txt and also not as a xml. 

what coul be my prob? It would be great if someone could help me. 


here the code: 

if($excel){   
   $excel.Application.DisplayAlerts = $false
   $excel.quit()

   $ExcelProcess=get-process excel
   $ExcelProcess | foreach {stop-process ($_.id)} 
   [System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel) | out-null
  } 

$xlo=New-Object -comobject excel.application
$xlo.visible=$true
$xlo.Workbooks.OpenText("directory\test_old.csv")  

start-sleep 4  

$file=("directory\test.xlsx")
$workbook.SaveAs($file)
$excel.DisplayAlerts = $False

$excel.quit()
$ExcelProcess=get-process excel
$ExcelProcess | foreach {stop-process ($_.id)}
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)




 thx a lot 

Chriz

Hello,

This forum is for community announcements and assistance with the community site only.  It is not for general PowerShell questions.  Please post your question in one of the general PowerShell forums.

Thank you,