Excel Macro to parse list of excel files and move them depending on a single cells value
Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it's > 600 move it to another directory and if it's < 600 move it to another one?
Software/Hardware used:
Software/Hardware used:
ASKED:
October 10, 2008 8:26 PM
UPDATED:
November 16, 2008 2:09 PM
RELATED QUESTIONS
- Recording cell value changes to another cell in excel using a macro
- I wish to have my macro copy a cell from a tab, then go to another tab and search specifically for the value of the initial cell.
- One cell acting on another
- How to accept user input and display the value in Excel 2007 macros
- Disable saving in Excel 2007
Answer Wiki:
You can use the Scripting.FileSystemObject to loop through all the files in a folder. And here's some code to read information from a closed workbook:
http://vbanet.blogspot.com/2008/11/cell-read-closed-files.html
HTH,
JP
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
