TransferSpreadsheet (1 Viewer)

[dreamz]

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.

 

[reclusivemonkey]

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.

 

[dreamz]

will give it a go.


Thanks