At work we have an ancient Ingress database that wont allow me to make links between tables using the SQL Query editor in Excel 2007.
My current solution is to generate the data in Crystal Reports, export it to excel and write a macro to then grab that data.
This works for my own purposes, but I am only contracted till June and would like to make these reports as automated as possible.
Is there a way to refresh the crystal report through an excel macro? Maybe through the likes of a batch file or shell script? Dont know much about either of those options but with only a minor java coding background am not even really sure what I should be looking to for the answer.
Thanks in advance!