Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Permission to use object denied. Shannon Excel Programming 3 November 18th 04 11:41 PM
Run time error 70 permission denied Sachin[_4_] Excel Programming 0 August 21st 04 05:07 AM
Permission Denied Error 70 Tom Ogilvy Excel Programming 0 August 3rd 04 04:56 PM
Permission Denied Audrey Ng Excel Programming 1 October 1st 03 07:20 AM
Error Msg: Permission to use object denied A. Nguyen Excel Programming 4 July 14th 03 09:05 PM


All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"