I AM NOT RE-OPENING THIS THREAD,
however I wanted to use Zynder's post to illustrate a point

Zynder,
One of the banes of my life have been the chunks of code that appear in this forum, which are a pain, to copy and paste into our programs.
They have annoying Line numbers, and lots of blank lines.

However your code posting was perfect.
Could you teach the code posters how to do that ?


Quote Originally Posted by zynder View Post
Here is another fast exporting to excel without looping through cells. It's a basic copy and paste. Good for exporting thousands of records.

Fast Export Flexgrid to Excel

[CODE]Private Sub cmdExportToExcel_Click()
Dim xls As Excel.Application

Set xls = New Excel.Application

xls.Workbooks.Open (App.Path & "\Template.xls")

xls.Visible = True