Click here to Skip to main content
15,887,683 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionPropertyGrid image Selection while Property is ReadOnly Problem Pin
VB 8.017-Jun-09 2:04
VB 8.017-Jun-09 2:04 
QuestionIssue while creating tables in ms access using VB.NET ADOX [modified] Pin
sivakumar.mariappan17-Jun-09 0:32
sivakumar.mariappan17-Jun-09 0:32 
AnswerRe: Issue while creating tables in ms access using VB.NET ADOX Pin
Johan Hakkesteegt17-Jun-09 0:47
Johan Hakkesteegt17-Jun-09 0:47 
GeneralRe: Issue while creating tables in ms access using VB.NET ADOX Pin
sivakumar.mariappan17-Jun-09 1:15
sivakumar.mariappan17-Jun-09 1:15 
AnswerRe: Issue while creating tables in ms access using VB.NET ADOX Pin
Ashfield17-Jun-09 1:25
Ashfield17-Jun-09 1:25 
GeneralRe: Issue while creating tables in ms access using VB.NET ADOX Pin
sivakumar.mariappan17-Jun-09 3:49
sivakumar.mariappan17-Jun-09 3:49 
GeneralRe: Issue while creating tables in ms access using VB.NET ADOX Pin
Ashfield17-Jun-09 8:57
Ashfield17-Jun-09 8:57 
QuestionRead the Excel upto used range Pin
Member 402761716-Jun-09 21:36
Member 402761716-Jun-09 21:36 
Hi,

I am new in Dotnet. I read the excel upto used ranges and print the data to messagebox. But I got Each value one by one after click the ok button.
But i need display the total data at once.

My Code is:

dim exapp as excel.application
dim exwork as excel.workbook
dim exsheet as excel.worksheet

exapp = New Excel.ApplicationClass
exwork = exapp.Workbooks.Open(TextBox1.Text)
exsheet = exwork.Worksheets("sheet1")


range = exsheet.UsedRange

For rcount = 1 To range.Rows.Count

For ccount = 1 To range.Columns.Count

obj = CType(range.Cells(rcount, ccount), Excel.Range)

MsgBox(obj.value)

Next

Next

exwork.Close()
exapp.Quit()
MsgBox("complete")
TextBox1.Clear()


Example: (In Excel)

No Name Age

1 Gopi 26
2 raja 24
3 mani 29


Output:

No,Name,Age
1,Gopi,26
2,raja,24
3,mani,29


But I got Each value one by one. I need full ouput as once. Please help me.

By
Gopi A
AnswerRe: Read the Excel upto used range Pin
Johan Hakkesteegt16-Jun-09 21:54
Johan Hakkesteegt16-Jun-09 21:54 
AnswerRe: Read the Excel upto used range Pin
Ebube17-Jun-09 0:09
Ebube17-Jun-09 0:09 
QuestionHow to identify the Users Network Credentials? [modified] Pin
Paramu197316-Jun-09 21:20
Paramu197316-Jun-09 21:20 
AnswerRe: How to identify the Users Network Credentials? Pin
Johan Hakkesteegt16-Jun-09 21:49
Johan Hakkesteegt16-Jun-09 21:49 
QuestionChange the size od MDI container in the parent form Pin
sohaib_a16-Jun-09 21:06
sohaib_a16-Jun-09 21:06 
AnswerRe: Change the size od MDI container in the parent form Pin
Dave Kreskowiak17-Jun-09 7:57
mveDave Kreskowiak17-Jun-09 7:57 
GeneralRe: Change the size od MDI container in the parent form Pin
sohaib_a17-Jun-09 19:20
sohaib_a17-Jun-09 19:20 
GeneralRe: Change the size od MDI container in the parent form Pin
Dave Kreskowiak18-Jun-09 11:23
mveDave Kreskowiak18-Jun-09 11:23 
QuestionUnistall from vb.net Pin
Mithun.Shitole16-Jun-09 20:21
Mithun.Shitole16-Jun-09 20:21 
AnswerRe: Unistall from vb.net Pin
dan!sh 16-Jun-09 21:52
professional dan!sh 16-Jun-09 21:52 
GeneralRe: Unistall from vb.net Pin
Mithun.Shitole17-Jun-09 1:53
Mithun.Shitole17-Jun-09 1:53 
QuestionCalling a C# exe with argument from vb code. Pin
mark_me16-Jun-09 13:06
mark_me16-Jun-09 13:06 
AnswerRe: Calling a C# exe with argument from vb code. Pin
Henry Minute16-Jun-09 14:11
Henry Minute16-Jun-09 14:11 
QuestionRe: Calling a C# exe with argument from vb code. Pin
mark_me16-Jun-09 17:27
mark_me16-Jun-09 17:27 
AnswerRe: Calling a C# exe with argument from vb code. Pin
Luc Pattyn16-Jun-09 14:22
sitebuilderLuc Pattyn16-Jun-09 14:22 
GeneralRe: Calling a C# exe with argument from vb code. Pin
mark_me16-Jun-09 17:31
mark_me16-Jun-09 17:31 
GeneralRe: Calling a C# exe with argument from vb code. Pin
The Man from U.N.C.L.E.16-Jun-09 22:45
The Man from U.N.C.L.E.16-Jun-09 22:45 

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.