Copy Sheet from close to open file

[Dokman]

Hello,

Close file name is "Datameetlijst.xlsx"
Open file name is "Alldata.xlsx"

I want to copy all the date from a close file (1 sheet) to the open file.

On the close file, the sheet name is "JA"
and on the open file it's "Data"

First it's clear every thing that's in the sheet "Data" and then it's must put in all the data from the close file.

I can do a script open Datameetlijst.xlsx after copying the file close Datameetlijst.xlsx
But I can file the rest to copy the data from one file to the other file.

Thanks for helping me out.

 

[Trevor G]

A method that could get you going is to record a macro and go through the actions you are doing manually and it will provide the script and method your using and then post the code in your thread and it should help providing a solution that will work for you.