Extracting Data from Closed workbook

please help

help..............

With the lack of relevant information, this will have to do.
The workbook with this code in it needs to be in the folder that has all the data files also.

Please Login or Register  to view this content.

Originally Posted by jolivanes

With the lack of relevant information, this will have to do.
The workbook with this code in it needs to be in the folder that has all the data files also.

Please Login or Register  to view this content.

Dear Sir, Tank you very much for your kind reply to help me. My Actual requirement is like this. I Have a Data folder which contain data for few years. there is sub folder for each year (like 2011, 2012, 2013) and each year folder there are sub folders for months (like January, February, March,..) and in every month folder there are workbooks for each day (like 1.xml, 2.xml, 3.xml,...) In each workbooks there are three data columns for each hour. I have master workbook which contain day in the column A and hour in column B. I need to fill Columns C,D,E of the master worksheet using relevant data.
So I want to write formula to do this automatically without opening the data workbooks, I have attached sample data workbooks and master workbook for your kind reference herewith
http://www.mediafire.com/download/w2...hlms1/Test.rar


Again I thank you very much Sir for your kind help.

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Originally Posted by antoka05

You could use this code:

Please Login or Register  to view this content.

Regards,
Antonio

Dear Sir,

Thank you very much for your kind help. the code give error in the middle and it has also replaced the values date and hour columns of the my master workbook. I want to only extract three data columns from data workbooks according to the date and hour in the columns A and B in the master workbook. any way again I thank you Sir for helping me

ueranda

Try this code that should do what you need and please excuse me for the other code that was not working fine.
Please correct the folders named Auguest with August else the code doesn't work fine.

Please Login or Register  to view this content.

Regards,
Antonio

@ueranda
Please don't quote. Refer to a Post # if you have to.

Dear Sir, I ran your code, but nothing happened. Any way than you sir for your help. Dear Sir, Is it possible to develop custom function
with four inputs (path name, file name, sheet name, cell name ) to get relevant data value according to the date and hour. I attached
sample master sheet herewith. In that column Column C contain path name, column D contain file name, column E contain Sheet name, columns F,G,H
contain Cells name. So it is possible to write function (getdata) with columns C,D,E,F as input to get value for column I

http://www.mediafire.com/download/0r...xi/Master.xlsx
again Thank you Sir for your kind help

ueranda

Who do you mean by Dear Sir? antoka05 or jolivanes?
Even if you mean antoka05, I assume that he/she also wants to know what the relevance of the date and hour is if you have a range (B2:D15) for all the sheets/workbooks

ueranda

Try (No error checking)

Please Login or Register  to view this content.

For post #11

Sir, I mean antoka05 by Dear sir. Anyway, Sir my original master sheet contain lot of other columns for various calculations. All those calculations are based on the date and hour. I need to extract some data for those calculations from relevant .xlm sheets.