Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    55

    Unanswered: OutputTo question...

    I am using an Output to to create a rtf document. I would like to beable to name the document "XYZ" and add the day of the report to the name.

    --XYZ02122003.rtf

    I am not having much like with this and would appreciated any input as to if this is doable.

    My path is C:\Program Files\Request DB\Reports\XYZ02122003.rtf.

    Thanks!

  2. #2
    Join Date
    Dec 2002
    Location
    Glasgow, UK
    Posts
    100
    I had a similar issue when exporting a table to excel, I used the DatePart function in the path name:

    "C:\Windows\Desktop\Export List " & DatePart("d", Date) & "-" & DatePart("m", Date) & "-" & DatePart("yyyy", Date) & ".xls", True

    Hope this helps

  3. #3
    Join Date
    Feb 2003
    Posts
    3
    i've been looking for how to do this for a while, thank you. One question though, would it possible to include data from a field in a report in the filename? such as if a field was called "first name" could that be used in the creation of the filename? if so how?

    thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •