Thanks Dave that worked great.

Now my worksheet name in the newly opened workbook is different
depending on the workbook opened but there is always only one
worksheet in the workbook. Is there a variable I can use to get the
worksheet name