Hi

How can i export my file using the macro (transferspreadsheet function) but export the file with the current date.

so if the filename is gonna be fhm.xls, i'd like it to be fhm09-01-2006.xls.

You need to create a string for the filename. So;


myDate = Date
myDate = Replace(myDate, "/", "-")
myFilename = "fhm" & myDate & ".xls"


Then just use myFilename in the transferspreadsheet function.

will give it a go.


Thanks :)