Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CopyFolder | Excel Programming |