Forum Discussion
Helper IHow get all sheet all workbooks folder ? stops at row error "File corrupt"
This is what I did to solve: Move all non-Excel documents to temporary folder beyond script reach.
I used
robocopy t:\ s:\ /L /S /MOVE /XF *.xl*
which should but didn't catch all png and txt files.
robocopy t:\ d:\ /S /MOVE *.png
robocopy t:\ d:\ /S /MOVE *.txt
Scripting should be capable to exclude non-Excel documents but beyond my current capability.
Helper IThis is what I did to solve: Move all non-Excel documents to temporary folder beyond script reach.
I used
robocopy t:\ s:\ /L /S /MOVE /XF *.xl*
which should but didn't catch all png and txt files.
robocopy t:\ d:\ /S /MOVE *.png
robocopy t:\ d:\ /S /MOVE *.txt
Scripting should be capable to exclude non-Excel documents but beyond my current capability.
- jennratten
Super User
You can limit the results to include only Excel files by filtering the Extension column of the table for text that contains xls.
