+ Reply to Thread
Results 1 to 4 of 4

How to if excel is running in a web browser

  1. #1
    stockbuildingsupply
    Guest

    How to if excel is running in a web browser

    i have a web application that streams an excel workbook to the client. i
    want to prevent the user from saving the workbook locally. the user should
    only be able to work with the workbook through the web browser. is there a
    way to tell if excel is being run in a web browser?

  2. #2
    keepITcool
    Guest

    Re: How to if excel is running in a web browser

    look at the workbooks' container property

    but be carefull you cannot do it in any open event
    as the container is only available when the book is
    fully loaded.

    --
    keepITcool
    | www.XLsupport.com | keepITcool chello nl | amsterdam


    stockbuildingsupply wrote :

    > i have a web application that streams an excel workbook to the
    > client. i want to prevent the user from saving the workbook locally.
    > the user should only be able to work with the workbook through the
    > web browser. is there a way to tell if excel is being run in a web
    > browser?


  3. #3
    stockbuildingsupply
    Guest

    Re: How to if excel is running in a web browser

    thanks for your response. can you show me some code to do this. when i try
    to run the code with Application.ActiveWorkbook.Container an error is
    generated. can this code be placed in the Workbook_Activate event?

    thanks

    "keepITcool" wrote:

    > look at the workbooks' container property
    >
    > but be carefull you cannot do it in any open event
    > as the container is only available when the book is
    > fully loaded.
    >
    > --
    > keepITcool
    > | www.XLsupport.com | keepITcool chello nl | amsterdam
    >
    >
    > stockbuildingsupply wrote :
    >
    > > i have a web application that streams an excel workbook to the
    > > client. i want to prevent the user from saving the workbook locally.
    > > the user should only be able to work with the workbook through the
    > > web browser. is there a way to tell if excel is being run in a web
    > > browser?

    >


  4. #4
    keepITcool
    Guest

    Re: How to if excel is running in a web browser


    it cannot be placed in the activation event directly.
    you'll need to delay it until activation has completed.

    In the workbook_activate event include an application.ontime
    to call the "containertest" with a 1 second delay.

    --
    keepITcool
    | www.XLsupport.com | keepITcool chello nl | amsterdam


    stockbuildingsupply wrote :

    > thanks for your response. can you show me some code to do this.
    > when i try to run the code with Application.ActiveWorkbook.Container
    > an error is generated. can this code be placed in the
    > Workbook_Activate event?
    >
    > thanks
    >
    > "keepITcool" wrote:
    >
    > > look at the workbooks' container property
    > >
    > > but be carefull you cannot do it in any open event
    > > as the container is only available when the book is
    > > fully loaded.
    > >
    > > --
    > > keepITcool
    > > > www.XLsupport.com | keepITcool chello nl | amsterdam

    > >
    > >
    > > stockbuildingsupply wrote :
    > >
    > > > i have a web application that streams an excel workbook to the
    > > > client. i want to prevent the user from saving the workbook
    > > > locally. the user should only be able to work with the workbook
    > > > through the web browser. is there a way to tell if excel is
    > > > being run in a web browser?

    > >


+ 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