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

William,

Thanks for the help/example.

It works great.

Brad 


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of William Benson
Sent: Sat 4/7/2012 11:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Generate Access Report to Two PDF files / or How to Copy a File with VBA code in Access
 
BTW I realize that will be same folder so modify to suit and maybe skip the
replace function and just use fully defined paths.
On Apr 7, 2012 12:44 PM, "William Benson" <vbacreations at gmail.com> wrote:

> 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
>>
>>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.