Macro code to import attachment from Outlook to Excel sheet?

[shenming]

Dear all,


I am using Macro in Excel to automate all the tasks I do in a day. I need you help.


I am using Excel to check daily inventory. At the moment, I have to copy & paste the stock data which is in *.txt format into excel sheet, then pivottable, format bla bla bla... The stock data will be sent to my email as an attachment *.csv (I am using Microsoft Outlook) everyday at 7:am. I am wonder if there is any code can help Excel to load the attachment automatically from my email or wherever into excel sheet without copying & pasting manually. Then I can format or do whatever I want with the loaded attachment in Excel.


I am so thankful if everybody have some idea about that.!


p/s: I have also attach the data sent to my email everyday (already saved as *.xlsx due to posting policy) if you want to see them. I want to load them in my macro template by hitting 1 button


Best regards,


Nguyen Bao An

 

[andrewafresh]

I am wondering if the QueryTables.Add method will help you - this can be used to get the data of a text file into your spreadsheet, then you could run some code to check how many rows there are in the new data and to perform the necessary formatting. To try this, you could record a macro using the Data ribbon then Get External Data From Text. Let us know how it goes. Btw, I couldn't see your attachment.

 

[shenming]

I am wondering if the QueryTables.Add method will help you - this can be used to get the data of a text file into your spreadsheet, then you could run some code to check how many rows there are in the new data and to perform the necessary formatting. To try this, you could record a macro using the Data ribbon then Get External Data From Text. Let us know how it goes. Btw, I couldn't see your attachment.

Thank you so much for suggesting, andrewafresh. But the attachment is still in email. Can we by using macro load it directly from email?
Sr I cannot find the way to upload attachment for your reference. please see on the link below:

https://drive.google.com/open?id=0B0jZEbUoH-ihVXlnYjJZZDdCY0U&authuser=0