I need to duplicate an Excel file, move it to a specific directory, remove duplicate records from the moved excel file, and send an email to a client with the cleaned Excel file attached. How can i do this and also remove duplicate records? because i cant see any vbo that does this
This is the code I developed in the code stage, but it is not successfully removing duplicate records. Could you help review it and guide me in the right direction so it performs as intended?
Thank you, everyone! I have resolved the issue. It is now working correctly—I needed to pass the handle and workbook into the object instead of using a new data item, and also in the input range i used "B:B" instead of "A:A". That was what was causing the error.
