Powershell script works only from a specific folder

Welcome Forums General PowerShell Q&A Powershell script works only from a specific folder

Viewing 4 reply threads
  • Author
    • #241220
      Topics: 1
      Replies: 1
      Points: 19
      Rank: Member


      I’m new to Powershell and to this fourm.

      I created a powershell script that reads from two different excel file and a few sheets within them and writes output to a new sheet in one of the two excel file. The script works perfectly fine from the a subdirectory under my desktop.

      However, if I copy the script and the excel files to a folder under c:\, the script does not run and locks the excel files as well.

      Seems like some basic parameter initiation but couldn’t figure out.

      I have these lines at the beginning:

      $objExcel = New-Object -ComObject Excel.Application


      Will the above lines work from any directory? Do I have to set any powershell configuration parameters (path etc.)?


      Everything else in the script is basically  assigning sheets to variables and processing cell values and writing to a new sheet.

      Appreciate any help!







    • #241289
      Topics: 13
      Replies: 41
      Points: 283
      Helping Hand
      Rank: Contributor

      Those lines should work no matter location.

      It would help if you included the full script (Please see how to format code).

    • #241598
      Topics: 1
      Replies: 2
      Points: 1
      Rank: Member

      The script must be running else it wouldn’t lock the files.
      How is your logging? Sounds like you’re lacking some as well as not having the right try/catch statements. See if you can narrow it down a bit by sprinkling in some status statements to see how far the script progresses.

    • #241814
      Topics: 5
      Replies: 244
      Points: 1,387
      Helping Hand
      Rank: Community Hero

      Please post your code wrapping with PRE tags and also take a look at ImportExcel module…


    • #241925
      Topics: 1
      Replies: 1
      Points: 19
      Rank: Member

      Thank you, guys!

      I think I found the issue. The script is locking the excel files and thus it becomes read-only. So, I am not able to write to a new sheet within the excel file.

      As a remedy, I have changed the script to write the output to a new excel file and it works.

      Now, the same script does not lock the file if I run it from a folder under my user home directory.

Viewing 4 reply threads
  • The topic ‘Powershell script works only from a specific folder’ is closed to new replies.