Thread: Nameing A New Workbook
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RANDY IN NC[_2_] RANDY IN NC[_2_] is offline
external usenet poster
  
Posts: 1
Default Nameing A New Workbook

I have a macro that copies a worksheet from a workbook.. pastes value
in a new workbook.. and then saves and closes it.. but is saving i
under one name.. what I need it to do is select a cell or combinatio
of cells to use as the workbook name.. is there a way to do this..

thank you Rand

--
RANDY IN N
-----------------------------------------------------------------------
RANDY IN NC's Profile: http://www.excelforum.com/member.php...fo&userid=2977
View this thread: http://www.excelforum.com/showthread.php?threadid=49558

Reply With QuoteReply With Quote