LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 161
Default object.CopyFile() has an error?

Sub Test()

Dim fo As Object

Set fo = CreateObject("Scripting.FileSystemObject")

fo.CopyFile "C:\file1.txt", "C:\data\file1.txt", False

End Sub


Before you run the above code, create an empty directory
of "C:\data". Oh course, "file1.txt" must exist on C: as well.

If you run the above code once, file1.txt will successfully
be copied into C:\data. However, run the code for a second
time and you get a run-time error 58 message that says:
"File already exists".

Why does this error message appear? I've set the overwrite
option to False, meaning do NOT overwrite.

If I set the overwrite flag to True, the file inside C:\data
never gets overwritten. No matter how many times I try.
(Neither files are set to Read Only)

So, I'm getting an error message when I use the False
option. And, I'm unable to overwrite the file if I use the
True flag.

What is going on here????




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copyfile Paul Excel Programming 1 October 8th 09 11:06 AM
FileSystemObject.copyfile KR Excel Programming 7 June 9th 06 07:19 PM
Help using FileSystemObject CopyFile Tod Excel Programming 1 May 12th 04 10:18 PM
CopyFile usage Garry[_5_] Excel Programming 1 January 19th 04 08:56 PM
FileSystemObject CopyFile with UserID/Password Tod[_3_] Excel Programming 0 January 7th 04 06:03 PM


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"