I am very new to VBA but I'm learning fast. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Eventually I want to create a report that looks at all the data in many different workbooks in a folder, searches for specific sets of data based on unique identifier codes and month, adds the data up and performs some equations. Then graphs it all... <o></o>
<o></o>
The kickers... I would want it to automatically happen on the 30th of each month.... and save the results for comparison for the next month (trending arrows). Is this at all possible?<o></o>
<o></o>
Eventually I want to create a report that looks at all the data in many different workbooks in a folder, searches for specific sets of data based on unique identifier codes and month, adds the data up and performs some equations. Then graphs it all... <o></o>
<o></o>
The kickers... I would want it to automatically happen on the 30th of each month.... and save the results for comparison for the next month (trending arrows). Is this at all possible?<o></o>