Hello,
I'm looking for a VBA Macro which will download a copy of excel from a specific folder from Outlook.
Once all the excel attachments are copied / downloaded, I need all the excel data into a new single spreadsheet.
For e.g. I've download 10 attachments to my computer in a specific folder. This 10 attachments are having data from A1:B20 columns. I want all the data from all the downloaded spreadsheet to be copied to a single spreadsheet into excel.
I'm receiving the excel attachment data in Vertical column (see attached for reference)
When at last the data is getting copied to new excel spreadsheet, it should get copied in horizontal. See cell A24 to U24 in attached spreadsheet.
Let me know if more clarification required on this.
Thanks !
Bookmarks