[RBASE-L] - Re: Reports to Excel

[Jason Kramer]

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 _vbscript_ experience.                                                         Jason Jason Kramer University Archives and Records Management 002 Pearson Hall (302) 831 - 3127 (voice) (302) 831 - 6903 (fax) On 3/9/2010 12:07 PM, karentel...@cs.com wrote: Right.  I create 100 .csv files (factory1.csv, factory2.csv), because every .csv file has to be "prettied up", saved as an Excel file, and then emailed to that factory.  Each .csv file has only that factory's information on it. Karen Karen, I read your first thread and I think you are saying you only create one CSV file then when they receive it they have to “Pretty it up”.  Is that correct? Then you mention they have to do this 100 times.  Is this because of the information they add on their end?   Jim