Hey
Part of the system I'm writing involves importing timesheets from Excel spreadsheets.
I have the importing sorted thanks to some help in other threads.
However, the importing is done 1 spreadsheet at a time, specified by the user.
What I need to do before that is check the integrity of the timesheets.
All the .xls are in 1 folder. I want to automatically, 1 by 1, open every spreadsheet that is found in that folder, move to the correct sheet, check a few cells have the correct info in, and close them - informing the user that it has either passed or failed.
I think I'm ok with most of it. The problem is how to get the code to search and open every .xls it finds in the folder (eg C:\timesheets)
Thanks
Part of the system I'm writing involves importing timesheets from Excel spreadsheets.
I have the importing sorted thanks to some help in other threads.
However, the importing is done 1 spreadsheet at a time, specified by the user.
What I need to do before that is check the integrity of the timesheets.
All the .xls are in 1 folder. I want to automatically, 1 by 1, open every spreadsheet that is found in that folder, move to the correct sheet, check a few cells have the correct info in, and close them - informing the user that it has either passed or failed.
I think I'm ok with most of it. The problem is how to get the code to search and open every .xls it finds in the folder (eg C:\timesheets)
Thanks
