Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    Blue Springs, Missouri, USA
    Posts
    108
    Thanks
    1
    Thanked 0 Times in 0 Posts

    XL2k won't open (IE5.5 & XL2K SR1)

    I have written this Excel program that does just fine on a desktop or a laptop. HOWEVER... when it gets launched on the web from IE, all the macros run asking for the user input BEFORE XL shows up. It is there... just not maximized. I want XL to open and then the macros prompt the user for the input. I have used the code in ThisWorkbook to no avail...

    Private Sub Workbook_Open()
    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Application.WindowState = xlMaximized
    more code...

    Any suggestions as to how I can get IE to allow XL to open first? Thanx.

    Dennis

    <img src=/S/gramps.gif border=0 alt=gramps width=20 height=20>

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: XL2k won't open (IE5.5 & XL2K SR1)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Dennis

    OK let me understand what you are trying to do here:

    You want to open a MS-Excel workbook within the Internet Explorer window.

    I think this can be done, but I am not sure if the macros will behave the way they do outside of IE.

    Plus your line: <font color=red>"Application.ScreenUpdating = False" </font color=red> will not show you any screen updating, so this maybe the problem.

    Can you be a bit more specific and tell me why you want Excel to load into IE?

    Better yet, ask this question in the Excel forum, of this lounge if you have not yet done so.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: XL2k won't open (IE5.5 & XL2K SR1)

    There is a registry setting, editable through the File Types dialog, that determines whether a document will open in the browser or in the associated application. Open Windows Explorer (or My Computer) and navigate to Tools>Folder Options...>File Types>XLS and (depending on your OS) click Advanced (or similar) to access the Browse in same window checkbox. Clear this checkbox to launch Excel when a link to an XLS is clicked.

    Now, if you have to do this on dozens of desktops, it's no fun, but you could use a .REG file to make the change in a logon script (NT network) or as Plan B, you could try to use code to launch the file. Due to the temporary deletion of old posts, my posts on this are not available, but if you are so inclined, I can try to reconstruct them. The idea is, the link is actually a script call, and the script uses VBScript to launch the filename as though it were entered in the Run dialog (Start>Run). This is a feature of the Windows Script Host and presumably will only run from a trusted host (e.g., My Computer or Intranet) and not from the Internet zone. At least, you have to assume that.

    So, depending on your needs, you do have some option to launch Excel.

    Second issue is, will your code run when launched that way? Word does NOT run its usual start-up code properly when using a regular link. So make sure you test. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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