CutAndPaste
Registered User.
- Local time
- Today, 21:57
- Joined
- Jul 16, 2001
- Messages
- 60
I've got a situation where I've got a whole load of Spreadsheets I want to import.
I can loop through all of the files in a folder OK. Some of them have got a DataRange defined within them and some not (two versions of Workbook used)
I want to move all of the files with the data range in to folder A and those without the data range in to folder B
Essentially I need to open each file in turn, if the range is present move the file to Folder A and if it is not move it to folder B.
How do I find out if a range is present?
Any ideas?
tx
I can loop through all of the files in a folder OK. Some of them have got a DataRange defined within them and some not (two versions of Workbook used)
I want to move all of the files with the data range in to folder A and those without the data range in to folder B
Essentially I need to open each file in turn, if the range is present move the file to Folder A and if it is not move it to folder B.
How do I find out if a range is present?
Any ideas?
tx
