How to import a closed workbook into an open one?

Hi there everyone,

I've spent a good length of time(more than I should have in all honesty) trying to find some code that works for me, yet it either fails or operates correctly then crashes.

Simply put, im looking for some code that when the command button in the user form is pressed, it will import (has to be import as there's merged cells, loads of rows etc in the closed workbook so can't copy)
The sheets into the current workbook.

That's it really, just so when you press the button, the code will import a workbook from a specified path into the current workbook.

I appreciate any assistance with this issue as it's currently hindering my progress on my project.

All the best,

Nathan

Originally Posted by 6StringJazzer

First, this doesn't make sense to me:There is no such thing as "import" a workbook. If you copy the sheets, they will preserve merged cells and everything else.

To copy sheets from a closed workbook, you have to open it. If the code is located in the same workbook that is to receive the sheets, you want something like this (untested though I would test if I had your files)

Please Login or Register  to view this content.

It works perfectly thank you so much!

My apologises about some of my statements made, I'm still fairly new to VBA, and trying my best to get a hold of it.

Appreciate the help though (will add reputation to your profile)

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!