0

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.

3
Contributors
4
Replies
5
Views
10 Years
Discussion Span
Last Post by hopalongcassidy
0

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:

0

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.

0

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:

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.