Loop through tables on other WB and Import to ThisWorkBook

[nordicdust]

I do hope for some and guidence here :-)

I Would like to copy tables from one workbook to this workbook.

I have started with a code to select the file that has the tables to loop though and copy.

When the file is selected with FileDialog it Calls another code and passes the FilePath as varible.

Now I would like to loop through the tables in that file and copy them to this one.

The workbooks will allways be the same as it is what I use for calculations of constuction jobs.
The sheet will allways be "BEREGNING"

File and pictures are uploaded.
Please ask if any questions

[nordicdust]

Any body have a little guidence for me ? :-)