 |  |  |  |  |  |  |  |
Connecting V.B 6.0 with ms-excel 2003
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Hi All ,
this is the first time i've entered this site ,and welling to help me about using visual basic 6.0 to connect with an excel sheet to be retreived it's data into the V.B.
So, If you please i need the V.B Code to complete my object.
thanx indeed, and i feel a pleasure to consult all through daniweb amazing site.
this is the first time i've entered this site ,and welling to help me about using visual basic 6.0 to connect with an excel sheet to be retreived it's data into the V.B.
So, If you please i need the V.B Code to complete my object.
thanx indeed, and i feel a pleasure to consult all through daniweb amazing site.
•
•
Join Date: Oct 2007
Posts: 147
Reputation: 
Solved Threads: 13
Junior Poster
You can do this using Call DoCmd.TransferSpreadsheet(...).
You can read about the parameters of this call in the Microsoft Access Help file under TransferSpreadsheet. You can use TransferSpreadsheet to either import, export or link a spreadsheet with a table. The spreadsheet can be Excel or even a Lotus 1,2,3 spreadsheet (read only).
Hoppy
You can read about the parameters of this call in the Microsoft Access Help file under TransferSpreadsheet. You can use TransferSpreadsheet to either import, export or link a spreadsheet with a table. The spreadsheet can be Excel or even a Lotus 1,2,3 spreadsheet (read only).
Hoppy
Hi,
i'm realy happy for joining (Daniweb) and i want to ask you about connecting vb 6 with microsoft excel, so please please help me....
thanx alot.
i'm realy happy for joining (Daniweb) and i want to ask you about connecting vb 6 with microsoft excel, so please please help me....
thanx alot.
•
•
Join Date: Oct 2007
Posts: 147
Reputation:
Solved Threads: 13
Junior Poster
•
•
•
•
Originally Posted by Abu-fa5ory 
Hi,
i'm realy happy for joining (Daniweb) and i want to ask you about connecting vb 6 with microsoft excel, so please please help me....
thanx alot.
Hoppy
|
Similar Threads
- use excel in vb.net 2003 (VB.NET)
- Retriving data from excel sheet into an asp page (ASP)
- Save data in IE6 page to Access 2003 file (Windows Software)
- Lock cells in Excel (IT Professionals' Lounge)
- Exprot to Excel in ASP.NET using C# (C#)
- Visual Basic Error on Word and Excel 2003 (Windows NT / 2000 / XP)
- Batch file in ASP.Net to convert Excel files into higher version (ASP.NET)
- Error message while importing data to Excel from the MySQL db (MySQL)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: VB Advanced TEXT BOX problems
- Next Thread: listbox to listbox question
| 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
