Copy values from VB program to spreadsheet

[TheDr]

Hello. New to this site and to VB as you're about to discover...

My problem seems simple: I require to copy values from my VB program to populate a spreadsheet.

More Specifically the values that the user enters in text/popup boxes I want to move to the corresponding field in the Spreadsheet. There will be up to 100 people using this function and would save large amounts of time in my office. My problems so far have been straight errors and overwriting of fields.

Any questions are welcome and any help you can give would be much appreciated!! Thanks. TheDr.

[vijaydiwakar]

Hello. New to this site and to VB as you're about to discover...

My problem seems simple: I require to copy values from my VB program to populate a spreadsheet.

More Specifically the values that the user enters in text/popup boxes I want to move to the corresponding field in the Spreadsheet. There will be up to 100 people using this function and would save large amounts of time in my office. My problems so far have been straight errors and overwriting of fields.

Any questions are welcome and any help you can give would be much appreciated!! Thanks. TheDr.

explain it with more detail

[willakawill]

Hi. This is fairly straightforward and quite a learning curve. You will need to include excel as a reference in your vb project and use excel objects in your code. This is called Ole Automation. TSDN is not a tutorial site and if you google 'vb6 excel automation tutorial' you should get more than you can handle.
Good luck