View Single Post
  #7 (permalink)  
Old May 20th, 2010, 07:44 AM
Shasur Shasur is offline
Friend of Wrox
Points: 3,060, Level: 23
Points: 3,060, Level: 23 Points: 3,060, Level: 23 Points: 3,060, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2005
Location: , , .
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts
Default

As vb5prgrmr has said, CSV files are the best option. You can save the CSV file as ".XLS". When the user opens it he needs to save a copy in Native Excel format

The best option would be to go for OpenXML and create Excel (.xlsx) file as an XML file through code

Cheers
Shasur
__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)
Reply With Quote