ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copyfolder (https://www.excelbanter.com/excel-programming/323873-copyfolder.html)

Alvin Hansen[_2_]

Copyfolder
 
Hi!
I use copyfolder in filesystemobject its working allright i'm happy
but if i copy a folder from a cd. the attribute on the folder gets to
read only and then i can't use copy folder next time, because i don't have
the permission to do this. Is there a way with the caommand copyfolder where
i can set the folder to bee read and write ??

Regards alvin


Tom Ogilvy

Copyfolder
 
use something like

SetAttr "C:\MyFolder\*.*", vbNormal

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi!
I use copyfolder in filesystemobject its working allright i'm happy
but if i copy a folder from a cd. the attribute on the folder gets to
read only and then i can't use copy folder next time, because i don't have
the permission to do this. Is there a way with the caommand copyfolder

where
i can set the folder to bee read and write ??

Regards alvin




Alvin Hansen[_2_]

Copyfolder
 
Hi
Tom i hav try but get an error
"BAd file name or number" my code is:
SetAttr "c:\" & tt & tal & kur1 & "\*.*", vbNormal

Before you write i try this
Set f = fso.GetFolder(fso.GetFolder("c:\" & tt & tal & kur1))
f.Attributes = 0
Set fs = fso.GetFile(fso.GetFile("c:\" & tt & tal & kur1 & "\*.*"))
fs.Attributes = 0

Well its working if i instead of *.* write filename.xls. but thats not good
for i dont know the file name nomally.


Reagrds alvin

"Tom Ogilvy" skrev:

use something like

SetAttr "C:\MyFolder\*.*", vbNormal

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi!
I use copyfolder in filesystemobject its working allright i'm happy
but if i copy a folder from a cd. the attribute on the folder gets to
read only and then i can't use copy folder next time, because i don't have
the permission to do this. Is there a way with the caommand copyfolder

where
i can set the folder to bee read and write ??

Regards alvin





Alvin Hansen[_2_]

Copyfolder
 
Me again
this working
SetAttr "c:\" & tt & tal & kur1 & "\valutatabel.xls", vbNormal
but this not working
SetAttr "c:\" & tt & tal & kur1 & "\*.*", vbNormal


regards alvin

"Tom Ogilvy" skrev:

use something like

SetAttr "C:\MyFolder\*.*", vbNormal

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi!
I use copyfolder in filesystemobject its working allright i'm happy
but if i copy a folder from a cd. the attribute on the folder gets to
read only and then i can't use copy folder next time, because i don't have
the permission to do this. Is there a way with the caommand copyfolder

where
i can set the folder to bee read and write ??

Regards alvin





Tom Ogilvy

Copyfolder
 
then I guess you will need to loop through your list of files. I many of
these accept wildcards, just like the DOS equivalent. I haven't tested it.

--
Regards,
Tom Ogilvy



"Alvin Hansen" wrote in message
...
Me again
this working
SetAttr "c:\" & tt & tal & kur1 & "\valutatabel.xls", vbNormal
but this not working
SetAttr "c:\" & tt & tal & kur1 & "\*.*", vbNormal


regards alvin

"Tom Ogilvy" skrev:

use something like

SetAttr "C:\MyFolder\*.*", vbNormal

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi!
I use copyfolder in filesystemobject its working allright i'm happy
but if i copy a folder from a cd. the attribute on the folder gets to
read only and then i can't use copy folder next time, because i don't

have
the permission to do this. Is there a way with the caommand copyfolder

where
i can set the folder to bee read and write ??

Regards alvin








All times are GMT +1. The time now is 11:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com