Date function

[Guest]

Hi,
Am trying to write a macro that concatonates the name with the date.. eg. report -> report03042002. Tried using Date$ but can't get rid of the '-' seperator. Any ideas?

 

[Dave Hawley]

Hi

Try:

Dim strFileName As String

strFileName = WorksheetFunction.Substitute _
("report03-04-2002", "-", "")