ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   FileSystemObject: object.Name [= newname] = Permission denied(Erro (https://www.excelbanter.com/excel-programming/310238-filesystemobject-object-name-%5B%3D-newname%5D-%3D-permission-denied-erro.html)

augustus

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


All times are GMT +1. The time now is 09:57 PM.

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