Hello Friends,

This group has been of great help for all starters like me. Thanks a
lot!!

It would be great if somebody could please help me with one of my
queries.

I have a workbook (say, old.xls) which contains a hidden sheet with
name "logo". This contains a sheet with an image (in form of company
logo) along with many other sheets. I have already written a macro
that copies a particular sheet from this workbook and generates a new
workbook (say, new.xls) with the same sheet name in the same directory
as old.xls. Now, I need to copy the image or logo in the hidden sheet
from old.xls to a new sheet in new.xls. The problem is, both the
workbook names 'old.xls' and 'new.xls' are dynamic in nature i.e. they
change each month so I cant hard code the macro with these names.

I am really stuck with this and it's impacting my work a great deal. I
would be highly obliged if somebody from the group could please help
me with this.

Thanks, and I look forward to hearing from somebody soon.

Best regards,
Ruchir