Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.
Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.
Private Sub cmdExport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdExport.Click exc = New Excel.Application() Dim r As Integer Dim c As Integer Dim CellsRange As Excel.Range If exc Is Nothing Then Console.WriteLine("ERROR: EXCEL couldn't be started") Exit Sub End If exc.Visible = True Dim workbook As Excel.Workbook = exc.Workbooks.Add Dim WorkSheet As Excel.Worksheet = workbook.Worksheets.Add For r = 0 To gridResults.Rows.Count - 1 For c = 0 To gridResults.Columns.Count - 1 WorkSheet.Cells(r + 2, c + 1) = gridResults.Item(c, r).Value Next Next For c = 0 To gridResults.Columns.Count - 1 WorkSheet.Cells(1, c + 1) = gridResults.Columns(c).HeaderText WorkSheet.Cells(1, c + 1).font.bold = True WorkSheet.Columns(c).autofit() Next End Sub
|Linked excel chart in PPT for export to other users||7||51|
|SKip past fields with no data||6||15|
|Need help with Clear Macro||4||26|
|split user ID and domain name from email addresses using formula||3||18|