import data in Excel

[BRUNO LABROUSSE]

Hello,

The command button I click on allows me to copy or import my data into a spread sheet in Excel.

I only know how to do this however for only a line (See example below). What I do not know is what line of code to write to import my data for a new date to the next line.

Example:

Date: B1 B2
26/06/2007 1 2
? ? ?

Literally, i am only able to import or copy a line and then I am blocked.

I would appreciate if you could explain how to do this.

Note: I am using visual basic 6 from my own computer.

Thanks

Bruno.

[Asgorath]

Hi
This a vb.net forum , mods will move your posts.
Search excel automation vb at google

[RobDog888]

Thread Moved.

Check my Office FAQ (link in my signature).

[BRUNO LABROUSSE]

Hello,

Thank you for the line of code regarding the transfer of data between useform and excel.

However I would like to be able to retain each line of data each time I transfer the data form the userform to the office application excel.

Currently, each time I transfer the data, it replaces the last set of data that I transferred previously.

Is there a way of overcoming this.

Thanks.

[Al42]

Change the row to which you're saving it.

[RobDog888]

Are you doing this in Excels VBA or using VB 6 or some other language?

Can you post your code?


Ps, thanks

[RobDog888]

Ok, so its VB 6 but it will be easier to see what code you have so far.

Also, my Office FAQ may help in some areas of your needs for this.