I receive e-mails from a customer that each have 1 CSV file attached. To date I have 120 received.
I am looking for an easy way to save all the attachements and then open them all and copy them to a single sheet.
The columns are always the same and there will never be any blank lines until the last row but the number of lines varies with each one.
Any ideas - even if I have to manually save them all to one location and all I can macro is the opening and collating to a single sheet.
Thanks
Rob
I am looking for an easy way to save all the attachements and then open them all and copy them to a single sheet.
The columns are always the same and there will never be any blank lines until the last row but the number of lines varies with each one.
Any ideas - even if I have to manually save them all to one location and all I can macro is the opening and collating to a single sheet.
Thanks
Rob