This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

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

General discussion
0

Sign in to vote
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

0

Sign in to vote

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

Your question is outside the scope of this forum.

Please read the following post (right at the top of this forum):

This forum is for scripting questions rather than script requests
-- Bill Stewart [Bill_Stewart]

Friday, November 30, 2018 6:17 PM
0

Sign in to vote

A simple search will find you many possible answers:

https://www.google.com/search?newwindow=1&source=hp&ei=1X4BXLCvE8jN_AaPk5r4AQ&q=powershell+excel+module&btnK=Google+Search&oq=powershell+excel+module&gs_l=psy-ab.3..0l4j0i22i30l6.977.6228..6507...0.0..0.233.2575.10j13j1....2..0....1..gws-wiz.....0..0i131j0i10.EtcdsMutw-U

\_(ツ)_/

Friday, November 30, 2018 6:19 PM