Okay. I am not all that familiar with ins and outs of VB code, but for people that are, my question probably is not all that complicated. If I were to have say 100 files in a folder, and I needed to do the same thing in each folder (so I create a macro with a shortcut key), rather than opening each file and running that macro 100 times, how would I write up a macro that tells it to open each file in folder (x), run my macro, then save and close and continue with every file within the folder until finished?
Then, for the more complicated question. Say I have a master report in Excel (came from an SQL statement ran through an HRIS database) that contains info. such as every employee’s supervisor’s name, their review date, salary etc. . .Now I want to run a macro that will take this master report and create a bunch of individualized reports; either in another Excel spreadsheet or into a template I created in Word. Basically, a supervisor report, giving each supervisor all of the info. of the employees that report directly into that person. For a huge report this could be a pretty tedious task of repeated cut and paste. (For various reasons, I am currently unable to create this report customized from our HRIS database into Access until I can obtain the ODE tools) So how could I create a macro that will tell it to, if Supervisor =(x) then take that info. and place in (y). etc. . . All info. in the same format, taken from the same report, but individualized into many personalized reports through a macro. Any suggestions?
