Thread: Reference a cell as part of a file name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
yobrokerboy yobrokerboy is offline
external usenet poster
  
Posts: 3
Default Reference a cell as part of a file name
I'm trying to figure out how I can have a macro save an Excel 2000 Worksheet
and get the name of the worksheet from a cell reference, i.e. FileNameDATE,
where DATE is the contents of a cell generated as =TODAY() in format
mm-dd-yyyy. For this discussion, the date is in cell A1.

Any and all input is greatly appreciated.
Reply With QuoteReply With Quote