I am wanting to write a macro to do the following:

Open a workbook named "File 2" that is in the same directory as a
workbook I currently have open (File 1) and am executing the desired
macro from.

Workbook File 1 may have been renamed from when it was originally
saved, so the macro can not refer to "File 1" explicitly. However, File
2 will be named File 2.

Copy some cells from File 1 workbook to Sheet 1 in File 2 workbook.

Save and close File 2 workbook.

Return control back to File 1 workbook.


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=486325