VBA help, creating a macro!!

[mccaco]

Hi I want to create a button on an Excel spreadsheet which will go into a folder, open up the most recent excel file. Add together several cells in that file (B12,B13,B14,I8,I13) then display the answer in the spreadsheet which contains the button (in cell J3).

I've already started the code and i've managed to open up the most recent file in the folder. As I am new to VBA I am struggling to finish off the second half of the code.

I will be grateful for anyones help.

 

[Joe4]

I want to change what the macro does so that instead of adding together the cells and displaying the value in the other workbook, it will copy a table in sheet 2 from the workbook just opened by the macro, and paste it into sheet 3 of the workbook which contains the button then closes the opened wb.

When first learning VBA, a great tool is the Macro Recorder. If you turn on the Macro Recorder and record yourself performing the steps manually, you will often get most of the code you need. At the very least, it gives you the building blocks for a good start.

Why don't you try that, see how far you get, and post back here (with your new code) if you get stuck?