Hi, I actually have this code working well now, however, I would love to change it to vb and put it in a pkg.

$objExcel = new-object -comobject excel.application

$objExcel.Visible = $True

$objExcel.DisplayAlerts = $False

$MMDDYYYY=[DateTime]::Today.AddDays(-1).ToString("MMddyyyy")

$Workbook = $objExcel.Workbooks.Open("\\files\Reporting\Census\DailyCensus_$MMDDYYYY.xls",0,$False,1,"password")

$worksheet = $workbook.Worksheets.Item(1)

$sheet = $workbook.Sheets.Item(1) # Activate the first worksheet

[void]$sheet.Cells.Item(1,1).EntireRow.Delete() # Delete the first two rows

[void]$sheet.Cells.Item(2,2).EntireRow.Delete() # Delete the first two rows

$worksheet = $workbook.Worksheets.Item(2)

$sheet = $workbook.Sheets.Item(2) # Activate the second worksheet

[void]$sheet.Cells.Item(1,1).EntireRow.Delete() # Delete the first two rows

[void]$sheet.Cells.Item(2,2).EntireRow.Delete() # Delete the first two rows

$Workbook.Password = ""

$a = $Workbook.SaveAs("\\files\Reporting\Census2\DailyCensus_$MMDDYYYY.xls")

$objExcel.Quit()

$Workbook=$Null

$objExcel=$Null

[GC]::Collect()