To answer some of your questions in general terms
1. Opening many files in order to copy a range from the files
Yes
2. Copying the ranges to my file which I called a "data bank"
Yes

Due the variable nature of the file names as you stated, you could use an
User Prompt in your macro - but this requires that a user knows the exact
name of the file - same with the variable range.

Would it not be possible to implement a naming convention strategy?
eg. File name = abc1806.xls or DailyOrders1806.xls.

I am by no means saying that it is not possible, just that with variable
file names and ranges the chance of human error increases.

HTH

"Frank Situmorang" wrote:

Hello generous people:

Can we use macro for
1. Opening many files in order to copy a range from the files
2. Copying the ranges to my file which I called a "data bank"
Our purchase orders was typed in the excel, and the name of the files is the
name of the project. I want to take the line items to be used in my file in
order to know name of the materials and Unit price.
To be more details I explain what I do manually:
1. Open the file name abc.xls
2. copy from range a1....e50 to my data bank
3. Tommorrow there is an additional range in the same file abc.xls range
a51..e75, I copied it to my data bank file
4. the next day there is a project PQR, so there is a file for all P.O's in
this project named PQR.xls, I operned it and copy say range A1...E40.. to my
data bank.

my question is how can I create an VBA for this routine job. There are 2
things variable.

1. File name could increased
2. range is the file could change/variable.

I appreciate your idea on how to solve the problem. Clould it be a prompt
parameter to fill in the name of the file and the ranges? in the middle of
the process of macro when it is running?

Many thanks,

Frank