I'm a newbie to powershell, and have been given the duty of learning powershell so that I can create a file loading process into sql.  I'm wanting to create a script that opens csv files in excel 2007, reformat the columns to all "text" so that when i save the file, every field is has a text qualifier. Could use a little help trying to point me in the right direction when it comes to the reformatting portion. Here is the excel connection code:

$xlExcel8 = 56
$Excel = New-Object -ComObject excel.application
$Excel.visible = $False
$Excel.displayalerts=$False
$WorkBook = $Excel.Workbooks.Open("C:\users\dgolliner\desktop\item_vend_pkg_factor_temp.csv") $WorkSheet = $Workbook.worksheets.Item(1)
$WorkSheet.UsedRange.FormatConditions.ToString ?????????? 
$Resize = $WorkSheet.UsedRange 
$Resize.EntireColumn.AutoFit()
$WorkBook.SaveAs("C:\users\dgolliner\Desktop\ivpf.csv", $xlExcel8)
$Excel.quit()

Thanks