How so you retrieve the name of a file you want to save before it
attempts to save it? That is how do you retrieve the name as entered
into the Save or Save As dialogue box before it actually saves it?

Thanks


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile: http://www.excelforum.com/member.php...fo&userid=5221
View this thread: http://www.excelforum.com/showthread...hreadid=264155

ACtiveworkbook.Name?

--

HTH

RP

"ExcelMonkey" wrote in message
...

How so you retrieve the name of a file you want to save before it
attempts to save it? That is how do you retrieve the name as entered
into the Save or Save As dialogue box before it actually saves it?

Thanks


--
ExcelMonkey
------------------------------------------------------------------------
ExcelMonkey's Profile:
http://www.excelforum.com/member.php...fo&userid=5221
View this thread: http://www.excelforum.com/showthread...hreadid=264155