Thread: save command
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
N242NY N242NY is offline
external usenet poster
 
Posts: 1
Default save command


I have been working on this now for a few days...

I need to make a macro that will allow me to save the document usin
some of the info in the worksheet. IE...

cell H3 has a name (John_Smith) and cell B2 has a date (11-15-04).

I would like to have the macro save the file using that info as th
name of the file.
John_smith11-15-04.xls

I have not been able to come up with the formula for the life of me.
my luck it cant me done...

Can anyone help me with this... :)
-Ro

--
N242N
-----------------------------------------------------------------------
N242NY's Profile: http://www.excelforum.com/member.php...fo&userid=1650
View this thread: http://www.excelforum.com/showthread.php?threadid=31367