Access button to get record from excel

[Jantu]

I want to create an access form which has two buttons the first button fetch data when clicked, should pull one record from excel file and once i am done with the record i should be able to click on the second button submit which will save the record in a different excel file please advise how to complete these actions on access form.. I'm looking for code for both these buttons.

[June7]

This is complicated. Requires VBA code to open Excel as an object and manipulate the object. Look at http://www.accessmvp.com/KDSnell/EXCEL_MainPage.htm

Why do you need to do this? Why is data duplicated?

[Jantu]

No. The purpose is to make the user work from the record from access form, so that each record is assigned to individual fairly. And excel to be kept away from any data manipulation

[June7]

That didn't really clarify anything for me.

Did the referenced link give you some idea of what is involved?

[Jantu]

It was useful but not apt to my query. I'm simply looking for a vba code for two buttons. Which pulls one record from an excel file and once the actions are completed.. When I click the second button it should save that record in a different excel file. Please advise

[June7]

I think the referenced link is relevant to your request. As I said, what you want is complicated. Requires opening Excel objects and manipulating in VBA. The referenced link has examples demonstrating that.

Click on "Importing from EXCEL Workbook Files" and scroll down to the "Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)" example.

Then click "Exporting from EXCEL Workbook Files" and scroll down to "Write Data From a Recordset into an EXCEL Worksheet using Automation (VBA)" example.

You would not have to save the imported data into a recordset, could just populate variables in code and then use those variables to write to other workbook. The first step is understanding how to manipulate Excel objects in VBA.

[Jantu]

Thanks. For the speedy reply .. I'll go through it and try to understand.. Will get back if need any clarification