Hello,
everyday I get several e-mails with either an excel or PDF file attached that has the following body:
Code: 1000
Date Company Currency Amount text
11.11.2018 AAA Dollar 1000 bla
11.11.2018 BBB Dollar 1000 bla
12.11.2018 AAA Dollar 1000 bla
I want to extract data for today's date into an excel file that looks like this:
Date Company Currency Amount Code
In the end the excel file should be filled out like this:
Date Company Currency Amount Code
11.11.2018 AAA Dollar 1000 1000
11.11.2018 BBB Dollar 1000 1000
My VBA skills are too limited to come up with a code by myself unfortunately. I am wondering if this is even possible to do via VBA?
everyday I get several e-mails with either an excel or PDF file attached that has the following body:
Code: 1000
Date Company Currency Amount text
11.11.2018 AAA Dollar 1000 bla
11.11.2018 BBB Dollar 1000 bla
12.11.2018 AAA Dollar 1000 bla
I want to extract data for today's date into an excel file that looks like this:
Date Company Currency Amount Code
In the end the excel file should be filled out like this:
Date Company Currency Amount Code
11.11.2018 AAA Dollar 1000 1000
11.11.2018 BBB Dollar 1000 1000
My VBA skills are too limited to come up with a code by myself unfortunately. I am wondering if this is even possible to do via VBA?