Convert Excel VBA to Access

[sotiris]

Hello,
I have an Excel File that has a macro inside. How can I convert
that macro in an Access file.

For example
1rst table with fields "QUANTITY" "LENGTH"
In that table is the data that the user insert

2nd table with fields "Length" "Blade Width"
In that table is the values for running the macro
only 1 record Length=6000 and Blade Width=5

3rd table with fields "Bar Number" Length"
The 3rd table is the result of the macro button.

Any help will highly appriciate.
Thanks
Sotiris

 

[sotiris]

The use of the excel file is for finding the
best way for cutting bars in the quantity and the
length that the user want.
The bar stok length is 6000mm and the blade width is 5mm.

The excel file has the macro for optimization
the quantity and the length for each bar in order to
have the minimum remains.

 

[sotiris]

I have attached the mdb file.
The table "tblCuttingList" the
table that the macro should create.

 

[sotiris]

This is one type of bar (there are many bars for use).

 

[sotiris]

Mr. Uncle Gizmo the Access file that I have attached is enough or there is something misunderstood.
Thanks for replying to the post.