Generating File Name on Save 1

[markfsi]

I have created a Macro which will generate a CSV export of data in my XLS Spreadsheet. However I am having trouble generating a file name. At the moment when I edit the Macro I can see the file name, what I would like to do is change the file name to be the current date in the format yyyymmddhhmm.csv

Does anyone have any ideas please?

 

[AnotherHiggins]

Hi, markfsi

Try this:
activeworkbook.saveas "C:\Test\FileName_" & Format(Now, "yyyymmddhhmm") & ".csv", xlCSV

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.