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 estão ofertando em média $26 para este trabalho
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.