Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

    Unanswered: Detecting IE or actual Excel

    I've been googling around and for the life of me I can't figure out how to programmatically discover if my end user has opened a spreadsheet in Excel or as an ActiveX object in IE. Some of the functionality in my sheet is not allowed to run in IE, so I would like to be able to detect this and disable certain buttons.

    Any ideas?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I know you could find out if the spreadsheet is open at all in Excel but I' m not sure how to check whether a specific instance is open in Excel. Perhaps you can get the handle and compare that with the instance handle....

    How accurate do you need to get?
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by Teddy
    I've been googling around and for the life of me I can't figure out how to programmatically discover if my end user has opened a spreadsheet in Excel or as an ActiveX object in IE.

    Any ideas?
    How would someone open your spreadsheet in IE? If I type a path to an Excel Workbook in the Address bar or use the Browser Open command it still opens the file in the Excel Application.

    Perhaps you can check the application name? Try.

    ?Application.Name
    Microsoft Excel

    If Not Application.Name = "Microsoft Excel" Then
    Msgbox "Please open this workbook in the Excel Application." & vbcrlf & _
    "Functionality is not available in IE Browser"
    Exit Sub
    End If


    I havn't tested this... may not work within the browser. Just my first guess to check for this condition.
    ~

    Bill

  4. #4
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by savbill
    How would someone open your spreadsheet in IE? If I type a path to an Excel Workbook in the Address bar or use the Browser Open command it still opens the file in the Excel Application.
    Dunno how Teddy's clients are doing it but try dragging an Excel file from a folder into an open IE window.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  5. #5
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Did you crack this one Teddy?
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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