Hi XL-Dennis, if by the above event you mean having the program I use automatically/remotely producing the individual reports then the above event is insurmountable. It cannot be done through automation. Perhaps if I outline what I want to do and why then someone may have an idea of how to go about it.
I produce web stats reports for 15 different sites every month in XL and instead of manually inputting the data into the sheets I would like to have the program I use email the data to me and then somehow extract that data and place it in the sheets. The first problem I have is how to take that data out of the emails and place it in XL, which is why I'm here. I have read that Outlook can export data so maybe I have this back to front and it's Outlook I should be asking about and not XL. Any thoughts?
Video Tutorials / Excel Dashboards Reports