+ Reply to Thread
Results 1 to 1 of 1

Scripting.FileSystemObject gives Permission denied

  1. #1
    Registered User
    Join Date
    03-31-2009
    Location
    Auburn Alabama
    MS-Off Ver
    Microsoft Office Excel 2007 (Windows)
    Posts
    99

    Scripting.FileSystemObject gives Permission denied

    Hello,

    Can someone tell me why I'm getting the error message "run-time error '70' Permission denied" when running the code below?

    The code below involves 2 sub-procedures which are being used to list folders on my computer.

    I'm running Vista Home Edition. I was under the impression that if I clicked the Windows icon and typed 'Excel' into the start search prompt, that by then pressing CTRL + SHIFT + Enter I would start Excel as Admin and not be denied permission to folders and files.

    As shown below, the first sub executes and calls the second sub which throws an error at the line "Cells(r, 3).Value = SourceFolder.Size". The debugger then shows "SourceFolder.Size = <Permission denied>".

    Thanks for any and all advice in advance! Your help is greatly appreciated!

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.
    Last edited by CrazyFileMaker; 03-16-2011 at 02:33 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1