dcsimg

Search:

Type: Posts; User: ronelpisan

Search: Search took 0.02 seconds.

  1. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Thanks for the correction but I want to merge those cells(after the paragraph). Thanks.
  2. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Thanks for sharing..but I want to merge those cells(after the paragraph). Thanks.
  3. VS 2010 Re: How to merge cells and put border on text after exporting datagridview data in ex

    Thank you sir for the correction.
  4. VS 2010 How to merge cells and put border on text after exporting datagridview data in excel?

    I want to merge and put borders around text. This text is comes after datagridview data.

    This is my code:
    Imports Microsoft.Office.Interop

    Public Class Form1

    Private Sub Form1_Load(ByVal...
  5. Re: How to add paragraph after datagridview data in excel using vb.net?

    Thank you very much man it works! I forgot to mention on merging cells in this cell "xlWorkSheet.Cells(lastRowForGrid + 2, 1) = "something here"". How to merge cells from range of 1st column(A) to...
  6. How to add paragraph after datagridview data in excel using vb.net?

    I want to add a text or paragraph after exporting datagridview data. I don't know how to add because there is no specific cell where I can put the text/paragraph or value and also because the data...
  7. VS 2010 Re: How to export to excel the autoincremented row value of datagridview using VB.NET

    Thanks..already solved.
  8. VS 2010 Re: How to export to excel the autoincremented row value of datagridview using VB.NET

    This is my revised code:

    For i = 0 To DataGridView1.RowCount - 2
    For j = 0 To DataGridView1.ColumnCount - 1
    xlWorkSheet.Cells(i + 18, j + 2) = DataGridView1(j,...
  9. VS 2010 How to export to excel the autoincremented row value of datagridview using VB.NET?

    I have datagridview with columns: FullName, Age, Birthday, Degree.

    The autoincremented row value displayed/located at the first column of datagridview that is automatically generated by the...
  10. VS 2010 Re: How to export data of a selected columns from database to excel using vb.net?

    Thanks..it works.
  11. VS 2010 How to export data of a selected columns from database to excel using vb.net?

    I have only one button on my windows form, a button that performs exporting of data from database to excel.
    It works in exporting but all those columns in database have exported. I want to export...
  12. VS 2010 Re: How to create dropdown list with source from another sheet in excel using vb.net

    Thanks it solved now.
  13. VS 2010 Re: Can you add a macro to Excel worksheet button through VB.NET?

    Solved! Thanks.
  14. VS 2010 Re: How to create dropdown list with source from another sheet in excel using vb.net

    Thank you my friend for the suggestion but same error shows. I think that changing of the code above has nothing to do with what I have asked for.
  15. VS 2010 How to create dropdown list with source from another sheet in excel using vb.net

    My code:


    Private Sub Button5_Click(sender As Object, e As EventArgs) Handles Button5.Click
    Dim xlApp As New Excel.Application
    xlApp.Visible = True
    Dim xlWorkbooks As...
  16. Re: How to insert code inside a command button in Sheet1 and not in module?

    Thanks so much for your help my friend. Finally found an answer from this link:...
  17. VS 2010 Re: Can you add a macro to Excel worksheet button through VB.NET?

    Thanks my friend and my problem has solved. Thumbs up
  18. Re: How to insert code inside a command button in Sheet1 and not in module?

    I got this error: Conversion from string "xlworksheet1.name" to type Integer is not valid. Error in line xlmod = xlworkbook.VBProject.VBComponents(xlworksheet1.Name).CodeModule.
  19. Re: How to insert code inside a command button in Sheet1 and not in module?

    Thanks my friend for your idea. When I try those lines of codes, it shows an error:167505
    Please help me to fix the error. Thank you.
  20. VS 2010 Can you add a macro to Excel worksheet button through VB.NET?

    I already created a commandbutton1 in sheet1 through vb.net. Also I already added a macro/vba code but in Module only.My only problem is on how to insert the macro/vba code inside the commandbutton1...
  21. Re: Add VBA code to excel worksheet from vb.net

    Please help me in putting vba code inside sheet1 and not in module1. Please I am begging.
  22. How to insert code inside a command button in Sheet1 and not in module?

    167461

    Here is my code in creating command button in excel.



    Dim xlMod As Microsoft.Vbe.Interop.VBComponent
    Dim objBtn As Object
    Dim celLeft As Integer
    Dim celTop As...
Results 1 to 22 of 26



Featured


Click Here to Expand Forum to Full Width