feathers212
04-17-2007, 06:24 AM
I have the following file created by a press operator:
5520
The coding in the "Pull Ticket" sheet is leftover from when the file was created/submited. The file (Job 123456 - Run Cover - Press 1010 - 4.17.2007.xls) is saved on our network in the following location:
V:\press\Forum\Count Control\Pull Tickets\Verification Needed
A supervisor will open this file and verify that all of the counts are correct. The supervisor will then click on the "Submit Supervisor Verification" button and select his name. On clicking OK, just the range of cells containing the ticket information is saved as a picture image in a newly created workbook (Job 123456 - Run Cover - Press 1010 - 4.17.2007 Verified.xls) in another network location:
V:\press\Forum\Count Control\Pull Tickets\Counts Verified
The new workbook is then emailed out.
Up to this point everything is working fine. However, now I want to delete the original file from the "Verification Needed" folder so that the verification process is shown as complete. Please help!!
Please note, I have built everything in Excel 2003, but the primary users of this program will be using Excel 97.
5520
The coding in the "Pull Ticket" sheet is leftover from when the file was created/submited. The file (Job 123456 - Run Cover - Press 1010 - 4.17.2007.xls) is saved on our network in the following location:
V:\press\Forum\Count Control\Pull Tickets\Verification Needed
A supervisor will open this file and verify that all of the counts are correct. The supervisor will then click on the "Submit Supervisor Verification" button and select his name. On clicking OK, just the range of cells containing the ticket information is saved as a picture image in a newly created workbook (Job 123456 - Run Cover - Press 1010 - 4.17.2007 Verified.xls) in another network location:
V:\press\Forum\Count Control\Pull Tickets\Counts Verified
The new workbook is then emailed out.
Up to this point everything is working fine. However, now I want to delete the original file from the "Verification Needed" folder so that the verification process is shown as complete. Please help!!
Please note, I have built everything in Excel 2003, but the primary users of this program will be using Excel 97.