View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Retrieve File Name before its saves

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