strangerobot
New Member
- Joined
- Oct 9, 2020
- Messages
- 6
- Office Version
- 2010
- Platform
- Windows
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!
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!