How to change a file's attributes to read-only with vba? 2

[steve728]

Will someone please show me how to change a local file's attributes from archive to read-only and visa versa?
I image it will be a shell call into the DOS????

Also. How do I copy a file from one location into another on the same drive?

Thanks,

Steve

 

[smedvid]

Perhaps chewck out the FileScripting Object
Dim objFSO As New Scripting.FileSystemObject

as a solution for the File Move... Check to see if file exists first then delete before move...
If objFSO.FileExists(lcFName) = True Then 'Delete existing copy!
objFSO.DeleteFile lcFName
Utilities.DelayTime 5
End If

File Scripting may also off change of attribute to read-only function, but I've never had the need to use such an option... htwh,


Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[TheAceMan1]

How are ya steve728 . . .

Here's an API with example that will do the job: SetFileAttributes API

See Ya! . . . . . .

 

[steve728]

Thanks folks! You always come through!

You both get stars!

Steve