Automate Data Extraction Without Opening Destination Workbook 

Thank you for this video. What a privilege to have you doing this videos.

This is realy helpful good sir. pls keep it up!

Hi there, If I understood your code correctly, you simply open the workbook, find something and then closes it. The only caveat is, the user don't see the workbook been open as you have turn the screen updating off. This is not very useful when I literally don't want to open the workbook as the size of the workbook can be rather large and it will take a long time if you keep opening and closing the workbook like how you had advised.

Complete VBA code for this video available here: www.exceltrainingvideos.com/automate-data-extraction-without-opening-destination-workbook-excel-vba/

Hi Takyar, I have like (300+ files in .iqy format) that has filename as sheetname whenever opened. The content of the iqy file is a website wherein it extracts the data to excel whenever it is ran. Would you be so kind to create a code that can bypass the name of the sheet to copy whatever the contents to a specific file?

Hi, how can I automate the data extraction from different sources in order to make a centralized database on excel?

1.Is it run the macro run auromatically? means when i open the workbook the "what do you what search for " should come automatically. 2.column header HDD, 3 values for this hdd in 3 rows, i want extract only one means first row only . Is it possible?

Sir I tried this VBA just want to know if there's multiple same entry name can we extract them all? or just the unique one?

Thank you in advance for your assistance :)

Hi Sir, I need a help For Ex : Row and Columns have some Data i need to extract the particular Row and Columns which has number more then "10".

Sir, I have one development file and 10 user files, every time i am moving the codes as a copy paste to all the ten files (8 Modules and many Click events and Change events). Is there any other ways to simplify this job, I cannot replace the files, since it has more data, so please let me know the better ways to move the codes from one file to other files via VBA itself.

I have a workbook that contains information we need for Data entry in another system. how would one use this macro to find the line and then show the whole row of information, rather than doing it cell by cell. When it is not an integer but test do you program it as a range?

can i run excel in system tray and display just the user form on the screen? I don't want the users to mess up the excel file. I just want to get the job done via user form like standalone app.

how would I go about extracting certain data ( Name and ID number) from a program called reflection and have it entered into excel?

LOVE IT!! SO EXCITED IT WORKS! How would I retrofit it to look in that other workbook, locate a *specific named sheet* "AcctgDept", then locate a *specific column name* "Tot_Inventory", then jump to the *last row of that column* and extract the Summed Total that's sitting in that last cell? (using your other macro to place those totals in that other sheet first, then I would run this one to go extract specific totals needed in this Master workbook???

sir in below code(transfer specific data to specific worksheets) data transferring one row below in every page from mydata page row 3,col 2 and row 3,2 is coming in row 2,col2 row2,col2 in another page (i want to row2 in row row 2 in seprae sheet)

Hello again, would you help. how to extract database from ticketmaster.com (price, seat...)? thank you sir.

Emails ain't coping alongside the data posted on Excel. How do I fix that?

Sir, I tried your codes and it works perfectly, the only problem i am facing is that I want to Extract data from multiple sheets of source file. and data of goal cell will be shown in each such sheets, so extracting of such data would not be a problem i guess. Please help me with codes,

How do I count rows from multiple workbooks with filtered sheets and have different last row please? I want VBA to count just the visible rows without having to start from row 1 all through.

What variable type should I use for extracting data like employee Id =40166041 against a person ID=201200? Thanks in advance

hello im working on a project and ive create a workbook in which i place data into a worksheet known as "processing" which serves as a main page in which i process detaied information from column A-L...i also have i another worksheet in this workbook label master and this is copy of everything thats ever been processed from my "processing" sheet..my goal is to create a macro which move the data from "processing" to "master" thru a submit button and then clear the data from "processing" so that i may start a fresh new batch but yet still hold history in the master sheet!!

thx for teaching me

perhaps do the samething i mentioned earlier but make an update info from another worksheet.

Mr. Dinesh Takyar Can you please show VBA code, How to copy only last row from closed csv file to new excel workbook. Parag Shah. Thank you

Thank you Dinesh, very helpful indeed. Just a question, if a user does not have access to the "source file", can he still run the macro that is in the "destination file" to update the file? thanks.

Hi i have to extract certain cell and paste them into other cell. i have 1000 work book to complete. can what u are teaching help me to achieve what i need?

Hi, Thank you very much for reading this comment. This tutorial is very very easy to understand and extremely helpful. I have a query and here is my situation. I have an excel file of size more than thirty MB and it can be accessed using the network and it keeps growing in size, every day. More than five users are actively using the file, on most of the day. Some of my users complain that when the file is opening and saving it is slow due to the network being slow. Hence, I need a solution for this. I have two solutions in my mind. Firstly, create a local file to each remote user and let them add their data and sync with the main file in the network when they close or click a button to update the main file. Secondly, add data to excel file in the network without fully opening the file. Do you have any suggestions? Thank you in advance and have a wonderful day.

you open the workbook literally in your code, the only reason the user can't see it is because you turn off the screen updating.

I would like to see how to make my whole Excel application work book to be invisible until I enter a user id and password into a dialog box on application start up...

How can I get a copy of your codes? that you are showing in your videos?

Hi Dinesh Sir, I want to Extract sheet one data from a closed workbook to sheet 2 in the current workbook with a single button in sheet 1 current workbook

hello sir, this is bhargav reddy from Bangalore. please tell me how to transfer the data from workbook to new workbook, is it possible to write code for that please help me sir, i am new to to vba please give me some easy tutorials if you have thank you.

Dear Dinesh sir .your upload very useful and easy to understand. sir I want to copy data in a particular rows from 100 different excel files in to new single excel file ,edit and put back the data in 50 excel files in the same row. All my 50 files use same excel format . Can you please explain. I am engg. Awaiting your reply. Thank you regards

Hi sir, I have a personal macro workbook and I have assigned a shortcut to it. If I press that shortcut it will automatically create PDF with same properties of Excel like name and path. But shortcut is not working when I open a Excel for first time. I want to go vb editor and run that personal macro. After that if I open 1000 new excels also this shortcut is working. How to make that shortcut to work from first time itself

the way you describe the subject , i would say with one word " the Master"....

Dear Dinesh, I am following your steps but I think I'm missing something as when i run the macro i get error message says the file could not be found in the pat. So can you help me please?

How about adding the not found data?

what if i wanna pull data from a worksheet from inside the current workbook. i wanna copy data from sheet 3 and paste into sheet 1. how do i do it.

Hi Sir, I need guide/help on transferring data from one excel (daily updates) to another (Protected workbook) excel automatically, Let me know is that possible ? If you have link please let me know, it will great full to my routine work. Thanks in advance!

I have a request. is there a way too make a VBA macro that will extract tables from a website. for instance when the table is broken up between multiple pages. I would like to have it to where it would only extract data tables and nothing else from the page. This is one of the websites I am interested in getting data from: www.scdhec.gov/administration/vr/vrdi/vrlist.aspx?c=-&pagenum=1 Can you help me with this scenario?

How to extract data from sheets that are made different each day , and the name of the sheets are for ex 2-28-14 ,3-1-14,3-2-14 ex

What code would I write to use a dropdown or lists instead of an inputbox?

How to submit some selected data from one userform to multiple sheets

Hi sir, I want to know how to define days and date if I have date and days in one cell....like Cells("A1"). value= Sunday 27/1/19 I need this cell value to be another cell ... please let me know

how to extract the data from specific sheet?

HI SIr,, thanks for update, have done the code , but having some error, can you please share mail id so i can send the file ,

after create the use form it can only run in excel? after i close the form i can not find the form again why?

Hello there. Is there a possibility that the VBA code extract the data just with the destination file name, without the path of the folder where the destination file is??

need help, how to replace the inputbox with combobox?

I've been watching all your videos, but I don't know why it doesn't work on my project your code is simple so I can understand it easily, but it always give error. its like your code only works individually and can't work dynamically. I don't know why.

How to subtract 2 digits in excel userform

@castor325, are YOU on drugs!? clearly everyone knows what the video is about. You had to show you know better?! Why don't you go make your own video?!

Suggest me a solution for following code Sub Test() Dim template As Workbook Set template = Workbooks("D:\Users.xlsm") End Sub After run this code error pop-up subscript out of range

Better yet use R and move away from ever using Excel

The title says „automate data extraction without opening workbook”. The title in my opinion is not right because you open the workbook in vba code. Of course you turn off screen updating so It’s not shown on the screen but you open it anyway. As far as I know it’s not possible to export data from one workbook to another which is closed without opening it in vba code. What you can do is to import data from another closed workbook without opening it in vba using ado library.

"Without Opening Destination Workbook"?, you ran the code from the destination workbook, it had to be opened.

100 lines of code to find a single value from another workbook . that can be done with a singe Vlookup macro....Come on !!!!!

Sir I tried this VBA just want to know if there's multiple same entry name can we extract them all? or just the unique one?