Re: Copy file with multiple names




"Jeff C" <JeffC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:76780D24-C1ED-46D1-B41A-B31D8ACB3114@xxxxxxxxxxxxxxxx
I was finally able to get some mainfraim reports spooled to download to
text
files every morning rather than useing Document Direct. The problem is
that
for every report that comes down every morning there are multiple copies
with
names the same followed by "name.#####.20071011024021.txt" for example.

I have been unsuccessful getting a script to move and rename the file.

So Far:

Dim oFSO
Set oFSO = CreateObject("Scripting.FileSystemObject")
oFSO.CopyFile "Q:\name*.txt","U:\DocDirectReports\name.txt", True

Can anyone assist?

Thanks in advance
--
Jeff C
Live Well .. Be Happy In All You Do

Before you decide HOW to do this, you need to work out
WHAT you want to do. Just renaming the files will not really
work: Sooner or later you will have two of these reports, and
you obviously cannot rename both to the same name. What
now?


.



Relevant Pages

  • Re: Error with DoCmd.Rename
    ... I had the form and the database window (report tab selected) visible at the ... Dim strStaff As String ... 'rename report to default name ...
    (microsoft.public.access.formscoding)
  • Re: Error with DoCmd.Rename
    ... I just told you how I was setting the value of strStaff. ... I can rename the report manually. ... Dim strStaff As String ...
    (microsoft.public.access.formscoding)
  • Re: Crystal Reports - Multiple datsets as the datasource
    ... I remember Crystal always allowed (since version 6 or even before, if memory ... how can we specify the multiple data sources at runtime? ... into the main report, each one using a different data set... ... > use multiple typed-datasets at design time, but a run-time when it came ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: sum unique records with multiple fields
    ... Use the Sorting And Grouping pane in report design to define how you want them sorted. ... wall, in a report as entered in the form? ... - one job has multiple plans ... a Plan ID and a Wall ID. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Sort by second field within a group header
    ... In the Sorting And Grouping pane (bottom of the window in report design), you can make multiple entries. ... You probably don't want the SEQORDER text box in the ACTIVITY Header. ...
    (microsoft.public.access.reports)