Downloading excel file name based on date Macro -

Downloading excel file name based on date Macro -

i'm trying write macro downloads info file, file name contains yesterdays date.

"text;http://www.mydomainname.co.uk/price_spiders_competitors_prices_gb/gbps aeg " & format(today() - 1, "yyyy-mm-dd") & " higher_than.csv" _ , destination:=range("$a$1"))

this isn't working

"text;http://www.mydomainname.co.uk/price_spiders_competitors_prices_gb/gbps aeg 2013-02-06 higher_than.csv" _ , destination:=range("$a$1"))

this does!

any ideas, have feeling dashes causing issue doesn't seem today -1!

thanks help

try function 'now()' instead of 'today()' current date , time.

as far know, excel doesn't have function 'today()' in vba. can utilize 'today()' in formula not in vba.

excel-vba