Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move and delete files
I would like to cascade down through my worksheet from top to the end and
process the data as follows. In column A I have a filename, I will have a constant source folder identified (ie. c:\input) and target folder identified (ie. c:\output). Column A test1.txt test2.txt test3.txt I would like to verify the file actually exists and IF it does then move it to the destination folder and delete the file. If the file does NOT exist then possibly highlight that cell so it can be removed from the worksheet. I had a function that checks the file but all UDF are no longer working. I use Excel 2007. Any help would be appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows then Move Up | Excel Programming | |||
Delete and Move Up | Excel Programming | |||
Selecting every other row to delete or move | Excel Discussion (Misc queries) | |||
Move text after delete | Excel Programming | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |