I have an external program that creates an excel workbook with several
worksheets. I need to have an existing workbook with the same worksheets and
data updated with the externally created workbook. If I let the external
program create the excel workbook with the same name I lose the macros within.

I cannot find an easy way or any way to update the existing workbooks with
the new data .

Any Help would be appreciated.

Bing59