Morning all,
Does anyone have a simple code that will do the following...
1. From a workbook called open Exercises_Results_Template
2. Go to a certain directory C:\TEMP\FILES
3. Open a workbook called SI_DIR_MASTER
4. Give the user the ability to save as SI_DIR_MASTER to SI_DIR in the folder of their choice.
5. Give the user the ability to save as SI_DIR_MASTER to SI_DIR_ in the folder of their choice.
6. In SI_DIR copy a selection of data say A12:AF4000
7. Paste text in Exercises_Results_Template starting at A12
8. Give the user the ability save Exercises_Results_Template as Exercises_Results in the folder of their choice.
Here's the thing there are three workbooks that I have to "grab' data from - in the same fashion as above - and paste it into seperate worksheets in the Exercises_Results.
Correct me if Im wrong but i figure if i have the above code I can just copy that for the other 2 worksheets, minus the last save as - step 8. At the very end the user could do a simple save.
Does anyone have a simple code that will do the following...
1. From a workbook called open Exercises_Results_Template
2. Go to a certain directory C:\TEMP\FILES
3. Open a workbook called SI_DIR_MASTER
4. Give the user the ability to save as SI_DIR_MASTER to SI_DIR in the folder of their choice.
5. Give the user the ability to save as SI_DIR_MASTER to SI_DIR_ in the folder of their choice.
6. In SI_DIR copy a selection of data say A12:AF4000
7. Paste text in Exercises_Results_Template starting at A12
8. Give the user the ability save Exercises_Results_Template as Exercises_Results in the folder of their choice.
Here's the thing there are three workbooks that I have to "grab' data from - in the same fashion as above - and paste it into seperate worksheets in the Exercises_Results.
Correct me if Im wrong but i figure if i have the above code I can just copy that for the other 2 worksheets, minus the last save as - step 8. At the very end the user could do a simple save.