Jason: I'll have to find out from their IT guy if he knows how to do that! I don't have a copy of the spreadsheet/macro that they use...
Karen > If there is already a macro/VBA module written that formats one file, > it is not too difficult to modify it to open each file, format it, and > save it. This is not quite the same as having each report generated in its > final format, but it will allow the end user to only run the macro once, > instead of manually processing all 100 files. > If you have a copy of the macro/VBA module, I can help you out. I > have some VBA and VB Script experience. > Jason
