fourstar787
08-13-2010, 10:39 AM
I have a workbook i send to other depts for them to fill in their section (worksheet) and then click a command button to send the worksheet (in the form of a new workbook) via email back to me.
I have saved the workbook on their pc's C drive so i can give it the req'd name before its emailed back (makes life simple when i receive it as the file name is already in a format i require)
what i wish to know is their VBA code i can use to delete the newly created file from their C drive after its sent (to avoid filling up their drive with files - without their knowledge)
I have only recently started using VBA but have learnt loads so far - but i have yet to find a good reference guide of all the available commands and their usage formats - hence why i have had to resort to asking here!
essentially - what is the vba code to delete a excel workbook ( name and location path are known!)
I have saved the workbook on their pc's C drive so i can give it the req'd name before its emailed back (makes life simple when i receive it as the file name is already in a format i require)
what i wish to know is their VBA code i can use to delete the newly created file from their C drive after its sent (to avoid filling up their drive with files - without their knowledge)
I have only recently started using VBA but have learnt loads so far - but i have yet to find a good reference guide of all the available commands and their usage formats - hence why i have had to resort to asking here!
essentially - what is the vba code to delete a excel workbook ( name and location path are known!)