Copy DBF file from C drive to Network Drive

M

mike

Any help with this would be great. I have a dbf file that
is automatically update on my C drive everyday. What
actually happens is I have some vb script that connects to
a sales program, creates a report, and then saves it as a
dbf on my C drive. Then some other scripts send out
reports based on that file.

I'm going out of town for a week so I was hoping to come
up with some code that will also copy the downloaded dbf
file to a Network drive in case the program fails while
I'm gone. That way I can find the problem and run it via
vpn, albeit more slowly.

The dbf file downloads using this line:

Global Const gstrISPMTDdbf As String
= "C:\...\...\...\Shipped.dbf"

Now I was hoping to place a copy of this on:

= "M:\...\...\...\Shipped.dbf"

THANKS!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I import multiple .dbf files into Access 2007? 0
excel 2010 opens blank from network drive 0
Link DBF files with long names 2
Import DBF files with MEMO fields 4
VBA code to copy multiple Excel files from C drive to network driv 1
Code linked to a form to copy and rename a file 3
Import all dbf files from a folder, access 2k7. 0
Excel 2010 fails to save or open from network drive 0

Top