You can use the Path property of the other workbook.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"narutard" wrote in
message ...

Hello

I am wondering if it was possibe to do a save a new book that i created
into a specific directory and with a specific name that comes from
another opened file

ex)

opened file -- c:\STUFF\date_work.xls

run macro

new file to save called -- c:\STUFF\date_work_update.xls

thanks


--
narutard
------------------------------------------------------------------------
narutard's Profile:
http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=389036