Updating links in a spreadsheet
 

I have a Parent spreadsheet that runs the Parent Macro.
I also have Infant spreadsheet that runs the Infant Macro.

The Parent Macro is grabbing info from the Infant spreadsheet and copy
it in the Parent spreadsheet.

I'm trying to have the Infant spreadsheet updated before copying the
info into the Parent spreadsheet.
So, I would like the Infant Macro to run on the Infant spreadsheet
once the Infant spreadsheet is opened by the Parent Macro. Like that,
the Parent spreadsheet would be filled with up-to-date information.

Anyone knows how to do that?

Thanks,

Kathy