[AccessD] Generate Access Report to Two PDF files / or How to Copy a File with VBA code in Access

Brad ... maybe typing too fast to get syntax right and using a Droid so I
can barely read my own keystrokes but...

How about
createobject("scripting.filesystemobject").getfile(FULLPATHOFFILE).Copy
replace$(FULLPATHOFFILE,FILENAME1,FILENAME2)
On Apr 7, 2012 12:37 PM, "Brad Marks" <BradM at blackforestltd.com> wrote:

> All,
>
> We have an Access application that is run automatically every night.
>
> It generates an Access report to a PDF file.
>
> There is now a need to automatically create two copies of this PDF file in
> two different folders.
>
> What is the best way to generate the first copy and then copy the first
> copy to a second copy with a different file name?
>
> (Did anyone catch how I used the word “Copy” 4 times in one sentence?  :-)
>
> Thanks,
>
> Brad
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>