Excel to Access to Excel for report automation
Hello everyone!
I am stumped. I want to automate my team. I send a report every few hours which has data that updates throughout the day in our company software. Currently I need to export to excel data from our software and copy the export into excel, run a macro, and resend a link to the new file template on our shared drive
What I would like to do is send one report out that will update throughout the day whenever I update my main report using tables or a data connection. To do this I am thinking I can paste the export into the macro, import the results into access, and then import directly into a template that can be updated all day long whenever I update the source. I tried going from excel to excel but you cannot share a workbook with a table.
Is this possible? Is there an easier way? Thank you in advance.
|