vb6 code to copy cell value from one workbook to another and it should be dynamic

I want to make a interface in vb6 which deals with excel file. Where we can select drive from drive box and select a excel file which is a source file and copy the value of cell from the source file and paste it into destination file's cell. my problem is i want it dynamic mean i will take excel file, sheet and cell from user in runtime.

> (this is the source excel file from where i want to copy the value of the cell)I m selecting excel file from filelistbox and then selecting a sheet from combobox where the sheets will b listed and then giving cell number from textbox and with d help of the command i show data that cell contains in a text box.

>(this the destination file where i want to paste the cell value that i copied) again in same way i giving the destination file and sheet n cell . i want the code for a command button which will paste the value of copied cell to the destination cell. i tried many thing but nothing works.

i made 2-3 function for copy cell but it doesnt work And i m using VB6

Please Login or Register  to view this content.

this is a vb6 rather than excel question which I reckon will be hard to answer without your project files-especially as the code looks a mess to me at the moment. it would also help if you stated what your actual issue is and where-if you just want a program built then post in the commercial forum as Kyle suggested