Is there anyway data within an excel spreadsheet can be amended and then re-saved with a different filename and in a different location, all from within Access.
Load Data from spreadsheet into table in Access - DONE
Save the spreadsheet with a different name in a different location - NOT DONE
Clear the data from the original spreadsheet that was loaded into Access - NOT DONE
Save the original spreadsheet (same name and location) - NOT DONE
Any help would be greatly appreciated