Is there a way to tell a macro to check cell A1 and if it finds any of the following words, delete the file. If it doesn't, run the macro.
If you find this in cell A1, delete the file:
Split
19
2000
2001
2002
2003
2004
2005
2006
2007
Thanks,
Benny
Is there a way to tell a macro to check cell A1 and if it finds any of the following words, delete the file. If it doesn't, run the macro.
If you find this in cell A1, delete the file:
Split
19
2000
2001
2002
2003
2004
2005
2006
2007
Thanks,
Benny
Hello Sweepin,
Which file is to be deleted?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I was thinking for a macro that
1 - Open file
2 - look for keywords in cell a1
3 - if keywords, delete the file you just opened
4- if no keywords, open next file.
Or, rather, can I make something that checks cell A1 for the keywords and if it's there marks the file as bad or something and then I can just sort and delete in the folder?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks