Vba logic to pull data from various workbooks based on date

[kosherboy]

Hello,
Need to write a complicated logic into vba:
Here is the scenario, there are two textboxes in a userform where one would enter a start date and an end date. The code i have would pull dated data from a workbook based on both dates. This is a relatively simple task for the code to do if we are dealing with one workbook, however, being that we have multiple workbooks, (minimum 10 mega bites each!) where every workbook represents an entire year's worth of data, the logic to create the vba code seems a bit more complicated.
The workbooks are named this way : DataBase2013, DataBase2014, DataBase2015, DataBase2016........

What logic would anyone suggest that i use?

I'm really looking forward to all responses

[JOHN H. DAVIS]

How many workbooks do you have? Are the Sheets names the same for each workbook? Can you share the code you are already using for one workbook?

[kosherboy]

Hi John,
Thanks for your reply
I currently have workbooks since 2013. I have this one main workbook that accesses information for only this year, trying to get it to access the previous years as well and years to come.
All the sheets are named the same way: "Offers".

So here the code (still in the works) for dealing with a single workbook:

Please Login or Register  to view this content.

Oh, and one more point!...if the user enters a start date of 1/6/2013 and an end date of 6/2/2016 how can a logic be written to have the code open all the workbook that are between those dates?

[JOHN H. DAVIS]

What about the sheet names? How is wsV defined? Is it the same in each workbook?

[kosherboy]

Yes, wsv is defined as a sheet and is found in each workbook. The only difference between all the workbooks is the year at the end of the filename.

Thanks.

[JOHN H. DAVIS]

With all the workbooks open, maybe:

Please Login or Register  to view this content.

[kosherboy]

Dear John,
THANKS!!!!
Your suggestion left me open-mouthed! It works great and i never would have thought of that!
I also appreciate very much that you went out of your way to write the code down for me

I did a couple minor changes to get the code to work with my system:

Please Login or Register  to view this content.

The only issue i am having is that the code works with the latest workbook and then moves down, i would like for it to start with the earliest workbook and move its way up.
is this possible?

[JOHN H. DAVIS]

When you use the workbooks collection it will start with the first one opened? The first workbook you open will be Workbook(1), the next Workbook(2) ect. ect.

[kosherboy]

When you use the workbooks collection it will start with the first one opened? The first workbook you open will be Workbook(1), the next Workbook(2) ect. ect.

Wow! Awesome! It worked just as you said
I am on such a high right now
Thank you and all the best to you!

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback and the reps.