Results 1 to 3 of 3

Thread: Excel and Internet Explorer OLE function?

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2003
    Posts
    7

    Unhappy Excel and Internet Explorer OLE function?

    Hi folks,

    I created a litte Excel VBA Program. The end user has to open a browser, go to a website. then he clicks on a button in the webpage in order to download some files in XLS format.
    Some users have a problem with OLE functions:
    Instead of having a message box asking him "Save as..."
    an Excel workbook is opened, embedded in the browser.
    I'd like to know if there is any possibility to enable /disable this OLE function?

    Thanks for any advice
    SuperPhil

  2. #2
    Evil Genius alex_read's Avatar
    Join Date
    May 2000
    Location
    Espoo, Finland
    Posts
    5,538
    Unfortunately, this cannot be set via code & is down to the individual machines' browser settings.

    Please rate this post if it was useful for you!
    Please try to search before creating a new post,
    Please format code using [ code ][ /code ], and
    Post sample code, error details & problem details

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2003
    Posts
    7

    Wink SOLVED]

    alex_read,

    Thanks for your advice and as you said, Dave Peterson explained to me how to do that:
    ==============

    Start Windows Explorer (not MSIE).
    View|folder Options (win98 version)--Tools|Options (in others????)
    File Type tab
    Scroll down to the Microsoft Excel Worksheet item
    Click on Edit
    There's an option to "browse in the same window"
    Uncheck it.



    ===========================
    Regards,
    Phil

Posting Permissions

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



Click Here to Expand Forum to Full Width