Click here to Skip to main content
15,923,557 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Drowning! Pin
Jon_Boy30-Mar-09 9:11
Jon_Boy30-Mar-09 9:11 
GeneralRe: Drowning! Pin
pack28-Apr-09 19:48
pack28-Apr-09 19:48 
AnswerRe: Drowning! Pin
Dave Kreskowiak30-Mar-09 9:27
mveDave Kreskowiak30-Mar-09 9:27 
AnswerRe: Drowning! Pin
Christian Graus30-Mar-09 15:29
protectorChristian Graus30-Mar-09 15:29 
GeneralRe: Drowning! Pin
EliottA31-Mar-09 2:21
EliottA31-Mar-09 2:21 
JokeRe: Drowning! Pin
0x3c031-Mar-09 6:42
0x3c031-Mar-09 6:42 
QuestionSave items to Database and get from datagrid Pin
Dave McCool30-Mar-09 0:54
Dave McCool30-Mar-09 0:54 
AnswerRe: Save items to Database and get from datagrid Pin
dan!sh 30-Mar-09 5:16
professional dan!sh 30-Mar-09 5:16 
GeneralRe: Save items to Database and get from datagrid Pin
Dave McCool30-Mar-09 7:51
Dave McCool30-Mar-09 7:51 
GeneralRe: Save items to Database and get from datagrid Pin
dan!sh 30-Mar-09 8:05
professional dan!sh 30-Mar-09 8:05 
AnswerRe: Save items to Database and get from datagrid Pin
anup keshari30-Mar-09 5:50
anup keshari30-Mar-09 5:50 
QuestionRemove() in vb.net Pin
vijay248229-Mar-09 21:23
vijay248229-Mar-09 21:23 
AnswerRe: Remove() in vb.net Pin
Christian Graus29-Mar-09 22:26
protectorChristian Graus29-Mar-09 22:26 
AnswerRe: Remove() in vb.net Pin
Steven J Jowett30-Mar-09 4:23
Steven J Jowett30-Mar-09 4:23 
Questionhow to use progress bar on copying file from embed resources to given path Pin
shivamgupta29-Mar-09 17:22
shivamgupta29-Mar-09 17:22 
AnswerRe: how to use progress bar on copying file from embed resources to given path Pin
Christian Graus29-Mar-09 21:03
protectorChristian Graus29-Mar-09 21:03 
Questionvb.net writes output to separate worksheets in separate workbooks Pin
jazzgirl29-Mar-09 17:20
jazzgirl29-Mar-09 17:20 
AnswerRe: vb.net writes output to separate worksheets in separate workbooks Pin
Dave Kreskowiak30-Mar-09 1:58
mveDave Kreskowiak30-Mar-09 1:58 
GeneralRe: vb.net writes output to separate worksheets in separate workbooks Pin
jazzgirl30-Mar-09 5:49
jazzgirl30-Mar-09 5:49 
GeneralRe: vb.net writes output to separate worksheets in separate workbooks Pin
Dave Kreskowiak30-Mar-09 6:52
mveDave Kreskowiak30-Mar-09 6:52 
AnswerRe: vb.net writes output to separate worksheets in separate workbooks Pin
Member 432084431-Mar-09 1:45
Member 432084431-Mar-09 1:45 
Questionproblem related to listview Pin
nazimghori29-Mar-09 9:17
nazimghori29-Mar-09 9:17 
hello every one

i want to create a report in excel using the items and sub items of listview

my code is:-
 Dim xl As New Excel.Application
   
Private Sub exc()
        Try
            Dim i As String
            i = CStr(1)
            Me.xl = CreateObject("Excel.Application")
            Me.xl.Workbooks.Add()
           
            Me.xl.Range("A1").Value = "Sr No."
            Me.xl.Range("B1").Value = "Area Code"
            Me.xl.Range("C1").Value = "Area Name"
            Me.xl.Range("D1").Value = "Alias"

            i = CStr(2)

           


            'Me.TextBox1.Focus()
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try
    End Sub


this i have written in form Load event

now code on button click event is:-

Private Sub btnreport_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnreport.Click
        Try
            xl.Visible = True

            Me.xl.Range("A" & i).Value = Me.lst1.Items(0).SubItems(0).Text
            Me.xl.Range("B" & i).Value = Me.lst1.Items(0).SubItems(3).Text
            Me.xl.Range("C" & i).Value = Me.lst1.Items(0).SubItems(1).Text
            Me.xl.Range("D" & i).Value = Me.lst1.Items(0).SubItems(2).Text


            i = CStr(CDbl(i) + 1)
           
        Catch ex As Exception
            MsgBox(ex.ToString)
        End Try

    End Sub

Exception from HRESULT: 0x800A03EC

i got this message in catch block cant get it so
please help..
Smile | :) Smile | :) Smile | :) Smile | :)
AnswerRe: problem related to listview Pin
Christian Graus29-Mar-09 9:52
protectorChristian Graus29-Mar-09 9:52 
AnswerRe: problem related to listview Pin
dineshrajputglobal29-Mar-09 22:58
dineshrajputglobal29-Mar-09 22:58 
GeneralRe: problem related to listview Pin
nazimghori31-Mar-09 5:43
nazimghori31-Mar-09 5:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.