Powershell Script not working after saving as .ps1 This topic contains 5 replies, has 3 voices, and was last updated by Vishal Rao B 1 year, 9 months ago. Author Posts April 19, 2016 at 2:49 pm #38017 Vishal Rao BParticipant 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 April 19, 2016 at 3:50 pm #38021 Joshua (Windos) KingParticipant What is the error you're receiving? April 19, 2016 at 10:59 pm #38029 Richard DiphoornParticipant I guess you're having the extensions in explorer hidden? And that's why the ps1 file doesn't run? April 20, 2016 at 12:06 am #38032 Joshua (Windos) KingParticipant It's possible the execution policy is restricting it from running. April 20, 2016 at 2:57 am #38033 Richard DiphoornParticipant Without knowing the actual error message, it's only guessing from our side... April 20, 2016 at 11:32 am #38080 Vishal Rao BParticipant Hi All, Thank you for your response. I should have mentioned my error clearly. I was able to resolve my error once I have saved my Code using Powershell ISE. Its running fine now. -Vishal Author Posts You must be logged in to reply to this topic.