VBA to Import Sheet - Excel VBA to Import Sheet from Closed Workbook

This example explains how to import sheet from other workbook with VBA Code. We can copy specific sheet from a closed workbook and paste into active workbook or transfer to any other workbook.

[RonaldStepp]

Thanks for the basic concept, I can see several ways to expand this into different methods of choosing the sheet and workbook to import and where to put them. Thanks again!

[mammothadventureracing]

Give the man a Bells. You my friend are a legend! Simple, quick easy.

[titsermon]

Thanks..
Very impressive.
I will try this later.

[dasworkshop]

I work with Excel in VBScript.  Is there a way to speed up Windows 10 and Office 2016, it is nearly 40 slower than the exact same code/spreadsheets in Windows 7/Office 2010.

[vinaysahu]

Thank you for this video. Could you please help if source workbook is not fixed then how to copy or select any workbook to import one sheet in the workbook we want?

[senthil]

How to import the data, s from other workbook to current workbook current page (Sheet1)

[waliasanjot]

In the same sheet if we want to import any file from user defined path then what will be the code sir

[viejitovela]

Good day and many thanks to help us with such usefull things. I have a question: how do I can use the same VBA code with and input windows to loop in the file and open any sheet? Please imagine that in this file I have 72 recipes and I want choose before to copy or to open on of those. Please be kind to teach me. I great appreciate your help. Chef Gio

[pravinkumar]

Sir, if I want to add a set of bulk excel data to a database without erasing the earlier data on a weekly/monthly basis, for example, employees monthly salary details, what would be the vba code? Please explain as I am dealing with such type of excel datas., thanks

[rajeshbhangale]

Hello Sir, thanks for this nice tutorial, what if we continuously want to copy this data from one sheet to another without manual button?

[pulse_sonic]

Very helpful video...If we want to export multiple sheets from another work book..Pls suggest

[egvNY]

The 'closed book ' in the title is not true, since you are actually opening the source book.
I would like to see how to copy from another source book without actually opening that source book.
I guess that will be using an ADO connection

[aadi]

What to do for automatically sheet name change based on cell value?

[muqitsiddiqui]

instead of fixed sheet name "Monday" could it be possible to popup dialog box for input "name of sheet".

[hiteshpatel]

I have one/two sheets which are common in two different Excel workbooks. How can I import one sheet from another excel workbook and replace the existing one.

[aritraghosh]

Hi, I want to import data from a specific named excel file to a template using the of any source file (e.g. I have a excel file called "xyz", I want to import the data of that excel to a template, some time that "xyz" might be on C drive, it also can be on D drive, it can be on any drive, so I want to import data of that by from any drive, by using the drive link). Need help, please help....

[vinice]

Hello Sir,

like wise i have multiple sheet name and multiple excels and i want to combile according to sneet names please assist.

[Serm]

Hi, thanks, working or me. Because I copied the sheet to another workbook, the new sheet has external links from original file. Is there any way that in VBA I can edit external links and refer them to the activeworkbook? Thanks again.

[dharmaraj]

Hi sir, how can I import excel using browse option. Pls guide me

[sangameshkuragund]

Sir kindly suggest how to extract file from other folder as file name entry in cell, if change the source name it need get other data.

Please help regarding this.