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.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen.
Visualize your data! ... really see it
To use the code to create a calendar from a q…