Is there a way that I can copy a sheet from one file to the next without
having to use:

Workbooks.Open "Filename", True, True

My problem is I wish to copy Sheet1 from one file to the next, then close
the original file. Currently I can make it work but I do not know how to
get back to the file once I perform the copy sheet command. Note: The
filename may change.

Thank you for your help in advance!!! (smile)

Mike