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

"GS" wrote:

Since you're using FSO.CopyFile instead of VBA's CopyFile, the
Script56.chm states...

"Note that CopyFile will fail if *destination* has the read-only
attribute set, regardless of the value of overwrite."


I found that the C:\data folder has the Read Only attribute set.
I tried removing it but it won't go away. If the folder is Read
Only,
why does the code write the file into the folder once, but on the
second time it fails?

BTW, I'm running this code on a personal laptop.


Changing the attribute via the Properties dialog does nothing if
Permissions do not allow 'write'!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
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 02:53 AM.

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"