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.

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 :icon_biggrin:

tHANX INDEED BRO.

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.

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 :icon_question:

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.