Tab to get records from two excel sheets

[janith]

Hi

Can someone help me with this, I plan to create a tab in access, which has text box and two buttons on it.

when I click the 1st button "Get Me Next" it should get the record from an excel sheet. and when i click the 2nd button "Case Closed". this records should get save in an other excel file.

Please help with the code for these buttons!!!

 

[spikepl]

In San Serriffe we accept dimes Roman (dR), but in an emergency can take USD or EUR.

In case you wish to give it a go yourself, show how far you are and on what you are stuck.