we have an access database that's linked to 6 Excel files. these files are exported manually from another program. Unfortunately, the file names are downloaded appending the date to the file name. I need a simple script to execute when i open an access database that will rename 6 Excel files by removing the date from filename located in a specific directory. and in one file remove the first and last rows.
16 freelancers are bidding on average $26 for this job
I have experience in programming scripts of this nature. I can easily create a script that will rename the files and remove the first and last rows of the sheet. Fast delivery and professional results.