I have a map with ~ 2000 excel *.xls files.
I need a macro that will do next things for all of my *.xls files from the given map
1)Add the company Logo image in the report ,excel footer - on the right
2) Image should be inserted only on the last page of the report (excel file)
3)Macro should cycle thru all my files from the given map and do the job described above.
4)Macro code should be efficient(get the job done for 2000 files as quick as possible)