dim openwb as workbook
workbooks.open filename:=Range("A1")
set openwb=activeworkbook
openwb.close

Magnivy Wrote:
I would like to create a macro that would open an Excel file based on
file
path that is indicated in a cell, and then close it. For instance, open
the
file for which the file path is indicated in cell A1, and then close
it.

Any advice you could provide on this would be greatly appreciated.

Magnivy


--
kwiklearner
------------------------------------------------------------------------
kwiklearner's Profile: http://www.excelforum.com/member.php...o&userid=31909
View this thread: http://www.excelforum.com/showthread...hreadid=521717