Excel VBA Copy Data from Closed Workbook

This Tutorial explains VBA Code for pulling data from Closed Workbook.

[tricksntales]

I was looking for the same concept but I was getting videos on copying data and "combining " it together one after is the first and simplest video i have seen which is related to my actual problem where I want to paste the data without combining it and paste it in non-empty you very much

[tayyabatfarms]

Nicely explained n easy to follow, thanks

[egvNY]

If you want read data from any workbook WITHOUT opening it, use an ADO SQL approach or the MS supplied ODBC connection, simple as it is.
Opening the file and then closing it is counterintuitive, ( to open it is what we are trying to avoid.)

[nadermounir]

Thank u very much. This is very helpful

[smanzoli]

Activate, select, copy, paste... yes VBA has these functions, but they are all slow an unnecessary, it´s just part of the auto-coding when you record a macro.
When you write it yourself, it´s exactly the opposite of best practices, NEVER do that, simply assign and link cells directly, it´s like 100x faster and you can change many lines in the code for a much simpler line.
example:
=

No need to select, copy, paste... and it runs MUCH faster. SImply as that.

And... you actually opened the source workbook... and closed it later. We can do that withou opening, using adodb connection and query.

[Kappacino]

Hi there, any idea why I will get an “run-time error ‘9’ subscript out of range”?

This error is at the code line “current

I have multiple worksheets in my existing opened workbook. I have already made sure that the sheet name matches the code as well

Appreciate your help..

[arunkumar]

Hi, Thank you for your Video.Nice one & Explanation..
I need a help?
Without Opening the Workbook i want to Read & write the Excel Sheet cell Valves & Save.

i have made a code, but while saving its showing read protection Error.I have checked the sheet security all are OK.

[sanjanasangani]

This works well! Thanks for sharing, however what if the data is of dynamic nature in source file, and I want to copy till last non empty cell. Could you share how to use this code then ?

[PravinPatel-menx]

Please post a video on VBA code how to copy & past from hide & locked worksheets

[jonnathanjon]

If the source file Jan Feb data is on a single sheet instead of seperate how can we pull respective month from the same sheet ? Ay suggestion?

[mayankgupta]

In my laptop there are titus classification so when im close the file they gave m pop up for classification which create problem when multiple files are open

[Tat-cxlr]

Bonjour
Merci pour votre partage
Ma macro ne fonctionne pas au niveau de copy:=
Pourriez-vous svp m’aider
Fred

[mahirbadanagki]

Thanks. It is not a closed workbook. you opened it and then closed it.

[dilipsanadhya]

Hi sir
I have a one ?
1. How to find a vale in row and according to mach value apply index and match apply

[asadmahboob]

The video content is not what is in the thumbnail. U open a file and copied the data and then pasted there....and at last closed the sourceworkbook.

Can u plz make a video on how to copy the data dynamically from a closed workbook without opening it....?