Forum Discussion
Formatting grandpa's TV overview
ScoIaro Sorry, overlooked your comment explaining that you had used the email option already. The automation can be achieved if you can/want to use Power Query. Rather than sending and e-mail, download the marked programs as an XML file (although the extension becomes .rss).
Then in PowerQuery, you can connect to the downloaded file do some transformations once and the next time it will all go automatic. Tried it works great, but it will have to be adopted to your own system.
Riny_van_Eekelen Thanks again!
Yes, that's actually what I described in my original posting. Sending the extract via email provided the best inital output for my purpose. I copy/pasted the email content into Excel, and used the second tab to display only the data I needed in the right order, however, that's when I started wondering if I could automate it with some sort of formula in order to simply copy/paste the data and Excel would create the correct list on tab 2 automatically, based on the content of column A (as I'm only interested in data of the lines that have content in A).
If that's not possible I'll happily have Mum send me the email once she's chosen the shows and do the rest (deleting the superfluous lines and adjusting the font, size and layout) manually myself - compared to Mum's previous workflow this will be much quicker already.
I just thought Excel had a more elegant solution for the second part too, so that once the Excel file is set up, she could copy/paste the email content and use the adjusted data in the second tab without having me to work on the file as well.
ScoIaro Sorry, overlooked your comment explaining that you had used the email option already. The automation can be achieved if you can/want to use Power Query. Rather than sending and e-mail, download the marked programs as an XML file (although the extension becomes .rss).
Then in PowerQuery, you can connect to the downloaded file do some transformations once and the next time it will all go automatic. Tried it works great, but it will have to be adopted to your own system.
Riny_van_Eekelen I took a look at Power Query and will definitely give it a shot!
(On top of that I contacted the Klack.de website and asked them to change the ANSI extracts to Unicode, so let's see who's quicker solving the problem, me or them. ^^)
Thank you very much for taking the time to check this and reply to me!