TButhe
04-22-2005, 01:32 PM
Hi,
I have a workbook template that tracks weights on our patients (thankfully, not mine). :thumb We are now coming out with a new workbook template that we are adding a BMI (body mass index, if you wanted to know) calculation to. The information needs to be transferred from the original workbook to the new one. What I am envisioning is that there would be a button on the new template that would run a macro that would allow them to open the old workbook and then would copy the data and paste it to the appropriate places in the new workbook and then the button would disappear. (I assume I could put that code in the on_New event because they will save it when they are done and won't use the template again unless they really mess up.) These are not the most computer savvy users so to have them copy and paste manually would be almost impossible. :whyme: I have no way of knowing what they called their files. I can do the copy and paste part of this (I think) and firefytr has helped me with the code to open another workbook. My problem lies with switching back and forth between the workbooks. How do I refer to a workbook when I don't know the name of it and what would the code look like for the button?
Sorry for the long explanation - it's probably a short solution!
I can't say enough good things about this forum!! I have looked at a lot of other places and this is the best organized IMHO.
THANKS to everyone here. I would have given up long ago with out you all. :bow:
I have a workbook template that tracks weights on our patients (thankfully, not mine). :thumb We are now coming out with a new workbook template that we are adding a BMI (body mass index, if you wanted to know) calculation to. The information needs to be transferred from the original workbook to the new one. What I am envisioning is that there would be a button on the new template that would run a macro that would allow them to open the old workbook and then would copy the data and paste it to the appropriate places in the new workbook and then the button would disappear. (I assume I could put that code in the on_New event because they will save it when they are done and won't use the template again unless they really mess up.) These are not the most computer savvy users so to have them copy and paste manually would be almost impossible. :whyme: I have no way of knowing what they called their files. I can do the copy and paste part of this (I think) and firefytr has helped me with the code to open another workbook. My problem lies with switching back and forth between the workbooks. How do I refer to a workbook when I don't know the name of it and what would the code look like for the button?
Sorry for the long explanation - it's probably a short solution!
I can't say enough good things about this forum!! I have looked at a lot of other places and this is the best organized IMHO.
THANKS to everyone here. I would have given up long ago with out you all. :bow: