Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileCopy and read-only
I'm using FileCopy to copy a number of files off the servers onto my C:
drive. Everything works fine except for the one file that is read-only. Any way to persuade FileCopy to copy over that file even if it is a read-only? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileCopy and read-only
I just tested it, and it copied a read-only file just fine (as I expected).
Sure there is not some other problem in the code? -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dkline" wrote in message ... I'm using FileCopy to copy a number of files off the servers onto my C: drive. Everything works fine except for the one file that is read-only. Any way to persuade FileCopy to copy over that file even if it is a read-only? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
FileCopy and read-only
Sub test()
Dim src$, dst$ src$ = "c:\test.txt" dst$ = "c:\test1.txt" If GetAttr(dst$) And vbReadOnly Then SetAttr dst$, vbNormal End If FileCopy src$, dst$ End Sub Dkline wrote: I'm using FileCopy to copy a number of files off the servers onto my C: drive. Everything works fine except for the one file that is read-only. Any way to persuade FileCopy to copy over that file even if it is a read-only? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filecopy in vba macro | Excel Programming | |||
Filecopy in vba macro | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy | Excel Programming | |||
FileCopy error | Excel Programming |