none
Read contents of Excel spreadsheet, then move file if a specific cell is filled RRS feed

  • General discussion

  • Little background: I work for a small business that contracts with a state government agency. We fill out monthly reports for them on Excel spreadsheets. What I'm hoping to do is write something to check if a specific cell is not empty (this cell would contain our internal invoice number after my boss submits the report for billing) and move the file to a different folder if that cell is not empty.

    I know this requires use of Powershell over a typical .bat file, but I don't know where to start.

    • Changed type Bill_Stewart Friday, March 15, 2019 12:34 AM
    • Moved by Bill_Stewart Friday, March 15, 2019 12:34 AM This is not "research information for me" forum
    Friday, November 30, 2018 6:12 PM

All replies