Macro doesn't resoleve in file statement csv

[mona4u]

Hi, 

I'm trying to output a CSV file and the macro can't be resolved for some reasons it output the macro without resolving  

ods csvall file='R:Location\Adjudication Status Metrics_&date..csv';

in the destination that's the file name I got 

Adjudication Status Metrics_&date.csv

[Tom · Accepted solution]

The macro processor ignores literals inside of single quote characters. Use double quote characters instead.

ods csvall file="R:Location\Adjudication Status Metrics_&date..csv";

Also did you really mean to use a relative path on the R: drive instead of an absolute path?

ods csvall file="R:\Location\Adjudication Status Metrics_&date..csv";

[mona4u]

Oh. Right 

Thanks so much