Dynamic file naming in VBA

[dperry]

Hi

I have written a basic macro that extracts data from an xl spreadsheet and creates a txt file. THe only issue I am having is determining how to automatically name the file as it needs to populate todays date in the file name.

i.e. the file name will be something like "FB upload [date].txt"

If someone could let me know how to do this I would be most grateful

thanks