I am writing a program where I prompt the user to save as: filename.

Later on I want to reference that workbook and pull a few cells out o
it. If I new the file name I would write:

Workbooks("book1.xls).Sheets("Sheet1").Range("A1") .Value

but since I don't know the filename I don't know how to reference it.
I would think it would be something like:

Workbooks(filename).Sheets("Sheet1").Range("A1").V alue or something bu
it isn't working for me.

While the sheet is open should I do a "find root directory and fil
name" routine and some how name that "filename"?

Any help would be appreciated.

Zeroma

--
Zeroma
-----------------------------------------------------------------------
Zeroman's Profile: http://www.excelforum.com/member.php...fo&userid=1662
View this thread: http://www.excelforum.com/showthread.php?threadid=31495