I need to automate some reports and I'm looking for advice on some ways I can do that. I receive a daily csv file that I then import into an excel spreadsheet which I then generate graph reports from. I then export the graphs as PDF and email them. I would like to automate the entire process including saving the csv attachment that comes in on email to a location on the network.
I have some experience using VBA to automate and perform functions. I'm not a fan of the reporting tools built into access which is why I'm using Excel but I'm open to using crystal reports if there is a reliable solution using crystal.