tljenkin
Board Regular
- Joined
- Jun 14, 2007
- Messages
- 147
Hi Guys,
I dont have the HTML maker so I am going to try to best explain this with words and I will make up an example for ease. Thanks!
Ok I have a master file that is linked to 2 feeder files.
Its January and a January folder has been created and the master file copied over.
However the 2 feeder files come from another source and the current month convention is reflected in them "MMYY". These feeder files have their own folder, within which is a date hierarchy of holders.
Without having to either manually update links, how can I use a macro that will do the following:
1) Look at a drop down in the master file and pick up the current month "MMYY"
2) Use the month above to detect which folder to look in
3) Be smart enough to substitute last month's name in the file "1214" with "0115" and link the master file to the correct feeder file
PLEASE NOTE: The reality is there is a 100 feeder files and 1 master file, so imagine how painful this is every month especially as there is very complicated sub folder structure where the feeder files can be found!!
I dont have the HTML maker so I am going to try to best explain this with words and I will make up an example for ease. Thanks!
Ok I have a master file that is linked to 2 feeder files.
Its January and a January folder has been created and the master file copied over.
However the 2 feeder files come from another source and the current month convention is reflected in them "MMYY". These feeder files have their own folder, within which is a date hierarchy of holders.
Without having to either manually update links, how can I use a macro that will do the following:
1) Look at a drop down in the master file and pick up the current month "MMYY"
2) Use the month above to detect which folder to look in
3) Be smart enough to substitute last month's name in the file "1214" with "0115" and link the master file to the correct feeder file
PLEASE NOTE: The reality is there is a 100 feeder files and 1 master file, so imagine how painful this is every month especially as there is very complicated sub folder structure where the feeder files can be found!!