ndendrinos
01-14-2007, 10:08 AM
Hello to all,
The code in the attachment copies from sheet "frontend" opens a folder that contains company folder , matches the company shown in C1 of front end to the respective company folder... opens it to the matching value of A1 in "frontend" (a month) and pastes the data in it.
I would prefer to use just one folder and do the same and need help in editing the code.
The part of matching the folder will have to change to match the given TAB and the part of matching the month will have to change also.
I have a problem explaining things this afternoon due to pressure from my wife that needs me to go shopping and is at the door ... but I will be back ASAP
Thank you.
The code in the attachment copies from sheet "frontend" opens a folder that contains company folder , matches the company shown in C1 of front end to the respective company folder... opens it to the matching value of A1 in "frontend" (a month) and pastes the data in it.
I would prefer to use just one folder and do the same and need help in editing the code.
The part of matching the folder will have to change to match the given TAB and the part of matching the month will have to change also.
I have a problem explaining things this afternoon due to pressure from my wife that needs me to go shopping and is at the door ... but I will be back ASAP
Thank you.