hi i am new to vb and was wondering if i can ask for some help. basically i have an excel spreadsheet emailed to me once a day. i have written a script to send this file from outlook to my folder in /c/users/documents/attachments/.

what i want to do is trend the data (only the ticket column and category column will be looked at) in the excel spreadsheet each day, so i want to create a macros button that will look into this folder and grab the most recent file and add plot it to the chart. not sure if its easier to select all the file i want in the folder at one time and then run the macros to spit out 1 spreadsheet, or if its easier to keep a running file and just tack on the next days data to it.


i included a zip file of 3 test data files and a key file. the key file contains ALL the categories i want to trend. not EVERY test file will have all the categories in the KEY file so for those days, the data will just be zero.

the name of the test files have the dates in them so i can have the macros reference this to know which date to plot (the X axis should contain the dates and the Y axis contains the Ticket count, and each of the 44 categories will be color coded so ill know which color means which category)test.zip