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.)
@ExcelDestination
3 жыл бұрын
Thanks
@tricksntales505
2 жыл бұрын
I was looking for the same concept but I was getting videos on copying data and "combining " it together one after other......This 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 sheet.......Thank you very much sir.........👍👍👍👍
@sumit_101
Жыл бұрын
It's works perfectly. Thank you.
@ExcelDestination
Жыл бұрын
Welcome
@nadermounir8228
3 жыл бұрын
Thank u very much. This is very helpful
@ExcelDestination
3 жыл бұрын
Glad it was helpful!
@sivachaitanya9596
Жыл бұрын
Thank you, really helpful🙌
@ExcelDestination
Жыл бұрын
Welcome
@tayyabatfarms
Жыл бұрын
Nicely explained n easy to follow, thanks
@ExcelDestination
Жыл бұрын
Welcome
@Kappacino1010
3 жыл бұрын
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 workbook.Worksheets(“MasterSheet”).Activate 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..
@arunkumar3085
3 жыл бұрын
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.
@sanjanasangani6124
2 жыл бұрын
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 ?
@mayankgupta4889
Жыл бұрын
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
@carameshnaragani7395
3 жыл бұрын
requested to paste link of code for downnload
@jonnathanjon1
3 жыл бұрын
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?
@ExcelDestination
3 жыл бұрын
you can set your code to month name and while pasting on current file by selecting the cell, where you want to paste
@Tat-cx1lr
Жыл бұрын
Bonjour Merci pour votre partage Ma macro ne fonctionne pas au niveau de copy:= Pourriez-vous svp m’aider Fred
@PravinPatel-me3nx
3 жыл бұрын
Please post a video on VBA code how to copy & past from hide & locked worksheets
@ExcelDestination
3 жыл бұрын
OK
@smanzoli
2 жыл бұрын
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: currentworkbook.Worksheets("Mastersheet").Range("A2:C11") = sourceworkbook.Worksheets("Jan").Range("A2:C11").value 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.
@vijaysahal4556
3 жыл бұрын
nice 👍👍👍👍👍
@ExcelDestination
3 жыл бұрын
Thanks
@dilipsanadhya365
3 жыл бұрын
Hi sir ..... I have a one ? 1. How to find a vale in row and according to mach value apply index and match apply
@ExcelDestination
3 жыл бұрын
you can take help from following tutorial : kzitem.info/news/bejne/q6-i2WaQjXuiiKQ
@asadmahboob1123
3 жыл бұрын
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....?
@ExcelDestination
3 жыл бұрын
ok
@puneetsharma3402
3 жыл бұрын
Plz make it dynamic sir..
@ExcelDestination
3 жыл бұрын
ok
@mahirbadanagki
3 жыл бұрын
Thanks. It is not a closed workbook. you opened it and then closed it.
Пікірлер: 34