Hi All,
I have Powershell code, I have tested it by pasting the code with Powershell
it ran without error.
But, when I have saved it as .PS1 file and trying to run it’s not working, I am receiving error
$path = “C:\Users\beeraval\desktop\Powershell_work\Source.xlsx”
$Excel = New-Object -ComObject excel.application
$Excel.visible = $True
$Workbook = $excel.Workbooks.open($path)
$Worksheet = $Workbook.WorkSheets.item(“MBR Metrics”)
$worksheet.activate()
$path1 = “C:\Users\beeraval\desktop\Powershell_work\loaa.xlsx”
$Excel1 = New-Object -ComObject excel.application
$Excel1.visible = $True
$Workbook1 = $excel1.Workbooks.open($path1)
$Worksheet1 = $Workbook1.WorkSheets.item(“Loaa Data”)
$worksheet1.activate()
$range = $WorkSheet.Range(“D:D“).EntireColumn.Delete()
$range = $WorkSheet.Range(“A4:AM206“)
$range.Copy() | out-null
$Worksheet1 = $Workbook1.WorkSheets.item(“Loaa Data”)
$Range1 = $Worksheet1.Range(“A4“)
$Worksheet1.Paste($range1)
$workbook1.Save()
Any help is appreciated