View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mabbutt
 
Posts: n/a
Default Saving with Macro


Hi

Is it possible to use a macro to retrieve a value within a specific
cell and save the workbook using that value for the file name?

For example if the cell A1 had the value details, then the macro would
save the workbook as details.xls

Thank you in advance for any help !!


--
mabbutt
------------------------------------------------------------------------
mabbutt's Profile: http://www.excelforum.com/member.php...o&userid=34294
View this thread: http://www.excelforum.com/showthread...hreadid=541058