 |  |  |  |  |  |  |  |
vb 5.0 to excel
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
Thread Solved |
From the posts in this website I see how to open an Excel spreadsheet from VB 5.0 but I don't see any examples of moving data (not an array) from vb to excel.
Can anyone show me an example?
Do you know of any books that would have this information?
Thanks
Can anyone show me an example?
Do you know of any books that would have this information?
Thanks
•
•
Join Date: Aug 2005
Posts: 15,494
Reputation: 
Solved Threads: 1478
You should study this MSDN article. I think it includes some example too.
[edit]Just noticed the link is for VB .NET, not VB 6. This might give you a start. I'm sure there are many examples. [/edit]
[edit]Just noticed the link is for VB .NET, not VB 6. This might give you a start. I'm sure there are many examples. [/edit]
Last edited by Ancient Dragon; Dec 25th, 2006 at 7:59 pm.
Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
Check this code:
Regards
Veena
Check this code:
Dim xlsheet As Excel.Worksheet TO READ FROM EXCEL Text1.Text = xlsheet.Cells(2, 1) Text2.Text = xlsheet.Cells(2, 2) ' TO WRITE INTO EXCEL ' xlsheet.Cells(2, 1) = Text1.Text xlsheet.Cells(2, 2) = Text2.Text
Regards
Veena
Thanks. I'm using vb 5.0 so I don't know if I could use that method. I tries Veena's tip and got it to work. Thanks
Thanks, Veena. That did the trick. Could you tell me how i can concatenate 2 vb fields into 1 excel cell?
Thanks
Thanks
•
•
Join Date: Nov 2006
Posts: 848
Reputation:
Solved Threads: 120
Practically a Posting Shark
Hi,
u can concatenate 2 fields using "&" this way :
I Hope it is clear. :lol:
Regards
Veena
u can concatenate 2 fields using "&" this way :
xlsheet.Cells(1, 1) = Text1.Text & ";" & Text2.Text You can or Cannot use any De-Limiter in Between. Or (No De-Limiter) xlsheet.Cells(1, 1) = Text1.Text & Text2.Text
I Hope it is clear. :lol:
Regards
Veena
 |
Similar Threads
- Excel to Web in Real Time? (ASP)
- How to write files to an Excel application (Visual Basic 4 / 5 / 6)
- grabbing source from excel file (was: please, somebody help me!!!) (Visual Basic 4 / 5 / 6)
- Macros in Excel (Visual Basic 4 / 5 / 6)
- Visual C++ and Excel (C++)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Help on making and using Database in VB
- Next Thread: license code
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
