Or save yourself the trouble http://www. remove this nebula-rnd.com/products/xlite.htm - There isn't anything in the CSV "standard" that would create a new sheet and I haven't run across anything that Excel uses.
hth Colin -----Original Message----- From: Israel, John R. I use xml for a few of our fancier reports. My technique is to built the Excel file the way I want it, save it as xls, then pick it apart. Again, it is a lot of work, but they are beautiful. Multiple worksheets, colors, formulas, pane freezing, etc. This might be the brute force method, but it works. John -----Original Message----- From: George Gallen If you don't mind switching from csv to xml, you define worksheets that way. Google excel and xml and worksheets It's a lot more work, but it works George -----Original Message----- From: Dave Davis That would be nice. I create separate CSV files and use macros to load each into a separate sheet. -----Original Message----- From: Jim Koca I am sending a CSV file to excel, and would like to divide it into separate worksheets. Is there a special value I can insert in the file which would cause the following data to create a separate work sheet ? Thanks, Jim Koca _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users