Renaming files?

[dcarr]

I have written several macros that firstly initiate a query, and then output the report as an *rtf to a location locally on my pc.
The way in which the file(s) are named are as follows
c:\reports\avXXPP.rtf, where XX is the week number and PP is the publication.
Does anyone know of a macro I could write that can rename the files so the XX and the PP are changed to suit (reference) a field within a table?
If this is not possible with the use of a macro does anyone know of any other way of completing such a function?
Thanks guys

 

[dcarr]

Renaming files

Thats great thanks. That is the first time i have used such a function. If I was to reference a table typically named tblweek, would I replace the "Form!" in you example with table!, or is there different syntax.
Thanks again