This is going to be difficult to explain, but I will give it my best..
I'm trying to create an Excel template file (I'll call it export.xls) that I can put into a folder and will pull data from other sub-folders located in that main folder.
For example: I have a folder called "Folder1" and within that folder I have many other sub-folders, called "test-01", "test-02", "text-03", etc. Within those test folders there will be an excel spreadsheet. The spreadsheets will all have the same name, say "data.xls".
Okay, what I need to do is:
When I open the export.xls file, it will automatically look for folders in that current directory that have the "-01, -02" etc, then pull information from the data.xls sheet located in each folder. The name "test" will change daily, so when pulling the info, the formula needs to exclude the "test" part of the name. The actually name of those folders (the test-01, test-02, etc) will include my state's initial and date (GA022111A-01). What I'm trying to do is ignore all the text/numbers before the -01.
Now I've searched around here and found that the best way is by use of a macro/vba. I've even been about to do something simple like copying the data from 1 cell from a workbook and pasting it into a new workbook, but to be honest, I just used what I found in the forums. I really have no idea how to write in vba and trying to figure out what others have done has been very difficult because I do not know what the code means.
anyway, hope that's enough to get started. Please let me know if you need more info..
thanks for any help... <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
I'm trying to create an Excel template file (I'll call it export.xls) that I can put into a folder and will pull data from other sub-folders located in that main folder.
For example: I have a folder called "Folder1" and within that folder I have many other sub-folders, called "test-01", "test-02", "text-03", etc. Within those test folders there will be an excel spreadsheet. The spreadsheets will all have the same name, say "data.xls".
Okay, what I need to do is:
When I open the export.xls file, it will automatically look for folders in that current directory that have the "-01, -02" etc, then pull information from the data.xls sheet located in each folder. The name "test" will change daily, so when pulling the info, the formula needs to exclude the "test" part of the name. The actually name of those folders (the test-01, test-02, etc) will include my state's initial and date (GA022111A-01). What I'm trying to do is ignore all the text/numbers before the -01.
Now I've searched around here and found that the best way is by use of a macro/vba. I've even been about to do something simple like copying the data from 1 cell from a workbook and pasting it into a new workbook, but to be honest, I just used what I found in the forums. I really have no idea how to write in vba and trying to figure out what others have done has been very difficult because I do not know what the code means.
anyway, hope that's enough to get started. Please let me know if you need more info..
thanks for any help... <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
