Dated folders to read files from

**GMorris82** · 07-12-2012, 09:28 AM

Hi,

I'm pretty pants with Excel and the last VB I did was around 14 years ago (Just had an age realisation moment there) so I wonder if someone can help me.

I need to read external sheets from folders based on dates. So for example:

On sheet titled "Dec-12", in cell A1 I have the value "Dec-12", and I want to read the sheet "figures.csv" from the relatively pathed folder "./Dec-12".
On sheet titled "Jan-13", in cell A1 I have the value "Jan-13", and I want to read the sheet "figures.csv" from the relatively pathed folder "./Jan-13".
On sheet titled "Feb-13", in cell A1 I have the value "Feb-13", and I want to read the sheet "figures.csv" from the relatively pathed folder "./Feb-13".

I tried making a Name alias based on cell A1 to pass into another name alias in the middle of the filename but it didn't work.

Googling the problem confuses me.

Can anyone help me with a simple solution for this?

Thanks in advance,

Greg

**JapanDave** · 07-12-2012, 10:03 AM

For 2007 it will be something like this.
BTW, is the cell formatted as a date?

Please Login or Register  to view this content.

**GMorris82** · 07-12-2012, 10:20 AM

The cell is formatted as a date right now, but it doesn't need to be.

Is there a good 1-pager I can read on how to implement this code? I'm outside of my knowledge/comfort zone on this.

Thanks for your help.

G

**JapanDave** · 07-12-2012, 10:30 AM

This is only a small fraction of the code needed to get what you are after. I just assumed you needed to know how to get the path. Sorry.

My advise is , post two sample workbooks. One where you want the data to be saved into and the other from where the data will be taken from, also a brief explanation of what data you need transfered. From there some code can be written

**GMorris82** · 07-12-2012, 10:42 AM

I will put something together and post when I get a chance. I can't post my actual worksheet due to sensitivity of the information.

Will have to be tomorrow now, as I'm occupied!

Appreciate your input though sir.

Greg

**JapanDave** · 07-12-2012, 10:43 AM

Not a problem. Of coarse take out sensitive data. I have subscribed to this thread so when ever you get a chance. cheers Dave

**GMorris82** · 07-16-2012, 08:26 AM

So attached is an example series of sheets akin to what I'm trying to achieve. I'm extracting from a data set using SUMPRODUCT.

How can I tie the folder name and sheet look-up to either the sheet name or the contents of cell A1?

Cheers.

G