User Name Password Register
DaniWeb IT Discussion Community
All
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
Reply
Join Date: Nov 2007
Posts: 2
Reputation: hatemkhzouz is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
hatemkhzouz hatemkhzouz is offline Offline
Newbie Poster

Question Connecting V.B 6.0 with ms-excel 2003

  #1  
Nov 23rd, 2007
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.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Oct 2007
Posts: 144
Reputation: hopalongcassidy is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 13
hopalongcassidy's Avatar
hopalongcassidy hopalongcassidy is offline Offline
Junior Poster

Re: Connecting V.B 6.0 with ms-excel 2003

  #2  
Nov 23rd, 2007
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
Reply With Quote  
Join Date: Nov 2007
Posts: 2
Reputation: hatemkhzouz is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
hatemkhzouz hatemkhzouz is offline Offline
Newbie Poster

Re: Connecting V.B 6.0 with ms-excel 2003

  #3  
Nov 23rd, 2007
tHANX INDEED BRO.
Reply With Quote  
Join Date: Nov 2007
Posts: 1
Reputation: Abu-fa5ory is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
Abu-fa5ory Abu-fa5ory is offline Offline
Newbie Poster

Re: Connecting V.B 6.0 with ms-excel 2003

  #4  
Nov 25th, 2007
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.
Reply With Quote  
Join Date: Oct 2007
Posts: 144
Reputation: hopalongcassidy is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 13
hopalongcassidy's Avatar
hopalongcassidy hopalongcassidy is offline Offline
Junior Poster

Re: Connecting V.B 6.0 with ms-excel 2003

  #5  
Nov 25th, 2007
Originally Posted by Abu-fa5ory View Post
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
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb Visual Basic 4 / 5 / 6 Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum

All times are GMT -4. The time now is 9:15 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC