+ Reply to Thread
Results 1 to 5 of 5

RunTime 70 Error - Permission Denied

  1. #1
    Registered User
    Join Date
    12-08-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    14

    RunTime 70 Error - Permission Denied

    Hi All,

    I am getting a runtime 70 error when I run the following Macro. Sometimes it happens after a few seconds and sometimes after a few minutes.

    Any ideas?

    Much appreciated

    Ross
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: RunTime 70 Error - Permission Denied

    Hello ross88guy,

    The main reason this error occurs in Internet Explorer is a variable has gone out of scope. Perhaps Internet Explorer is waiting for you to answer a dialog, or you were redirected to another web page, or an object variable in your code failed to set and is equal to nothing.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    12-08-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: RunTime 70 Error - Permission Denied

    Hi Leith,

    Thanks for the advice. I have tried to work out which object is failing to set but I cant seem to work it out!

    is there any way that you could cast a quick look over the code and see what you think?

    Any help that you can give willl be more than appreciated

    Ross

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: RunTime 70 Error - Permission Denied

    Hello Ross,

    I will in the morning when I wake up. It is 1:41 AM here in California.

  5. #5
    Registered User
    Join Date
    12-08-2010
    Location
    london
    MS-Off Ver
    Excel 2007
    Posts
    14

    Re: RunTime 70 Error - Permission Denied

    *whispers* sorry for waking you up....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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