•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Visual Basic 4 / 5 / 6 section within the Software Development category of DaniWeb, a massive community of 455,973 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,828 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
Views: 1977 | Replies: 4
 |
•
•
Join Date: Nov 2007
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Connecting V.B 6.0 with ms-excel 2003 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: 144
Reputation:
Rep Power: 2
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
•
•
Join Date: Nov 2007
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
tHANX INDEED BRO.
•
•
Join Date: Nov 2007
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
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: 144
Reputation:
Rep Power: 2
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.
So, what's your question?
Hoppy
|
•
•
•
•
•
•
•
•
DaniWeb Visual Basic 4 / 5 / 6 Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
Similar Threads
- Retriving data from excel sheet into an asp page (ASP)
- use excel in vb.net 2003 (VB.NET)
- Save data in IE6 page to Access 2003 file (Windows Software)
- Lock cells in Excel (Techies' Lounge)
- Exprot to Excel in ASP.NET using C# (C#)
- Visual Basic Error on Word and Excel 2003 (Windows NT / 2000 / XP / 2003)
- 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
