View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
augustus augustus is offline
external usenet poster
 
Posts: 49
Default FileSystemObject: object.Name [= newname] = Permission denied(Erro

Hi,
I am using Excel to change folder name, but I'm getting

Permission denied:
(Error 70)

I'm running Windows2000 and Office 2003, I tried on Windows95 with Office
2000,not a problem. I didn't have problem using Move method.

Me code:
If IsNumeric(Left(f2.Name, 5)) Then
f1.Name = Left(f2.Name, 5) & " - " & strJobName
Worksheets("ProperlyDeveloped").Cells(i, "B").Value = f1.Name
i = i + 1
Exit For
End If

Why?

Regards
Augustus