Is it possible to delete Excel files from a network share drive folder where the Excel files are empty? The Excel files have various and different file names and some Excel files within the network share drive folder contain data. I only want to delete Excel files that contain no data.
The Excel files are automatically dropped in the network share drive folder as part of a Macro process in Access. The files are dropped regardless of whether the final table contains data or not.
Hi @StephK717
Try to use power automate desktop - where you can design the flows which iterate through each excel files- check whether the excel file is empty either using rows count= 0 and then delete file accordingly.
Nived N 🚀
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
Share
Report
All responses (
Answers (
18,138
