Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    17

    Unhappy Unanswered: Problem Runing Macros at Internet Explorer

    I have a excel file in a webserver, and the users must run it
    directly from the internet explorer.

    The problem is : when a user click over the excel table link it opens
    the excel in internet explorer but when he/she clicks to run the macro
    the macro give some sheet errors.

    "The "sheets" method from the "_Global" object have failed."


    I dont know why this happen, when the user download and then run
    the macro works great, but in internet explorer the macro turns crazy.
    Last edited by watchachi; 03-08-04 at 13:59.

  2. #2
    Join Date
    Jan 2004
    Posts
    17
    I found a workaround for this:

    you need to set in user's machine to not browse .xls files
    at the same window. you do that like this:

    Go to Control Panel > Folder Options
    then click on "File Types"
    Select the XLS file type and then click on "ADVANCED"
    and uncheck the box "Browse at the same window"

    Then it works..
    but anyone know a way that i can do that
    at the server side, so the user dont need to do that much
    of things to run the macro.

Posting Permissions

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