Automating CSV update received in email

[strangerobot]

Hi Excel experts!

I have a question on whether the following action is possible. I want to automate my product inventory update from my supplier (without needing to leave my computer on). They send me a csv file every day with their current stock levels. Is there a way for:

- the csv file from supplier gets downloaded into the cloud automatically from email
- the csv file in the cloud to run a VBA macro that I have to update information and format
- the updated csv file gets hosted on a link, where my import plugin can download the csv file from and update my store stock levels

If this is possible, can you point me toward the right direction please as I am not fluent and not sure what these "actions" are called.

Thank you for your time!

 

[pjmorris]

The simple answer is yes. You need to use PowerQuery: on the 'Get & Transform' tab of the Data Ribbon, select 'New Query', 'From File', 'From Folder'. Then navigate to your cloud folder and Import the data. Whenever the folder is updated a 'Refresh' of your spreadsheet will grab the new data.

I wouldn't try to use VBA its much too difficult to maintain.

HTH