Sub test() Application.Run "Book5!test1" End Sub
Mechanic said:This worked, however it ran the macro stored in the child and put the results in the parent (calling workbook) workbook. I wanted the child workbook to run data stored in the child and place the results in the child leaving the parent untouched. How do I do that?
Mechanic said:I tried Ahnold's suggestion and it works. Unfortunately, it will be code intensive for all the references I have. Just_jon's suggestions seem like what I need but unfortunately I couldn't get the first one to work. Could you please offer some code so I can see if I'm doing it right. The second suggestion:
is the most applicable to my work but it still ran in the calling (parent) workbook. For 'do stuff, I ran:
I see what the intent is, but it ran in the parent workbook, perhaps I used it incorrectly. Is there something else I should do to make it work?
Please forgive my rookie skills but, I', basically self taught.
I appreciate everyones help. Thank you,