Hi.
I'm working on a large report at the moment, which consolidates information from a number of sources. However, I've hit a slight roadblock with some of the information.
I have a series of tables I want to automatically access via a macro. These tables sit in a folder. The name of the folder changes according to the month. So, for example:
c:\information\012008
c:\information\022008, etc.
Also, the files within these folders also include the date: i.e.
c:\information\012008\sheet 012008.xls,
c:\information\022008\sheet 022008.xls, etc.
Once I've accessed these files I then need to copy across information from folders to my master file, but without the above steps I can't do that. Any help with this would be greatly appreaciated.
I'm working on a large report at the moment, which consolidates information from a number of sources. However, I've hit a slight roadblock with some of the information.
I have a series of tables I want to automatically access via a macro. These tables sit in a folder. The name of the folder changes according to the month. So, for example:
c:\information\012008
c:\information\022008, etc.
Also, the files within these folders also include the date: i.e.
c:\information\012008\sheet 012008.xls,
c:\information\022008\sheet 022008.xls, etc.
Once I've accessed these files I then need to copy across information from folders to my master file, but without the above steps I can't do that. Any help with this would be greatly appreaciated.