Solved: Import sheet from closed work book?

[Martin B.]

Hi everyone!

I have found some codes online but are having problems getting them to work. I was hoping that someone here maybe could help me.

I need a code that imports a specific sheet from a closed workbook and places the content of that sheet in an specific existing sheet in open workbook.

Closed workbook:
test1.xls

Sheet to export:
sheet1

Open workbook:
test2.xls

Want the data from the imported sheet to appear in:
sheet2


I would deeply appreciate if someone would like to help me.

Many many thanks,
Martin

[stanleydgrom]

Martin B.

See:

Extracting data without opening file--please help!!
http://www.mrexcel.com/forum/showthr...25#post2066825

copy data from closed workbooks
http://www.mrexcel.com/forum/showthread.php?t=412589

Get Data from closed workbooks with formulae
http://www.excelforum.com/excel-work...ple-files.html


Have a great day,
Stan

[Martin B.]

Thanks a lot Stan!