>Hi Nadya,
>
>I forgot to tell you that I had to put ' in my file's name like this one :
>
>filename="Account'Activity'For'"+act1m+"'From'"+strtran(dtoc(dat1m),"/","-")+"'to'"+strtran(dtoc(dat2m),"/","-")+;
> "'report'created'on^"+strtran(strtran(strtran(ttoc(datetime()),"/","-"),":","-")," ","^")+".pdf"
>
>If I use SPACE instead this ' to seperate the words, this command will give me an error :
>
> set printer to name "Acrobat PDFWriter"
> report form finabala noconsole to file &filename
>
>the name of the file created is:
>
>account'activity'for'11100-00'from'01-01-2002'to'09-18-2002'report'created'on^09-18-2002^08-17-26^pm.pdf
>
>I hope I answered your question.
>
>Thanks again
Hi,
First of all, instead of macro you can use name expression report form FinAbala noconsole to file (fileName), so spaces should not be a problem. But I would probably use _ instead of space or ' Also are you sure, you need such long file name? May be you can create a special directory instead? Or put this info in the report itself? Finally, you can easily retrieve date of file creation...
If it's not broken, fix it until it is.
My Blog