PriceD
asked on
Data import and chart automation
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.
Thanks for your help!
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.
Thanks for your help!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.