I misread your post, sorry about. I assumed you were using code.
How are you exporting the report? If you are going to File-->Export, then
you can simply edit the file name.
If you're exporting through the query, do not except the overwrite when
prompted and rename the file. If you are exporting using a macro, you will
need to either rewrite this function in VBA or use one of the previously
> Thank you for your reponse.
> Although, I have used some VB Scripting, I am not a programmer (learning a
> little more each day) and in this particular case - I have not utilized any
> VB scripting.
> This database's sole purpose is to import a single table overwritting the
> prior one, from that table a report is generated and exported using the
> following path.
> F:\Collections\Collectors\Payment History Reports\Payment History.xls
> I guess I was thinking that something could be written within the path (some
> coding) that would tell it to increment. I suppose I'm way off, however, if
> you feel that VB scripting will accomplish this... Any guidance in the right
> direction is most appreciated.
> "xRoachx" wrote:
> > Hi Gina -- If the report is run once each day, you can concatenate the name
> > and the date to form the name of the file. This is probably the easiest
> > option. If you need more specific help, post your code you use to export
> > your report.
> > "Gina" wrote:
> > > Everyday I import a table into Access (an exported query from People Soft).
> > > The data is manipulated and then a report is exported to an Excel file. I
> > > have a Macro performing this with a push of a button on a form that is on the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10602-incrementing-output-files.html
> > > Start Up menu. Because it is automated, the name of the exported report is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10602
> > > the same each day and is therefore overwritting the prior days report.
> > >
> > > My question: Is there a way to increment the name of the report to export.
> > > I know that People Soft and some others have this process of incrementing the
> > > name. I hope I have given enough details.
> > >
> > > Thanks.
> > > --
> > > Gina