+ Reply to Thread
Results 1 to 2 of 2

Invoke exclusive excel process on opening this file

  1. #1
    JB2005
    Guest

    Invoke exclusive excel process on opening this file

    An excel workbook is required to start/use an exclusive Excel.exe process
    whenever it is opened.

    This is to enable it to use specific tools/options settings which may
    conflict with those already in use by other open files that may share an
    existing process.

    eg. some workbooks will use "Auto calc.", others "Manual calc." options

    Any ideas?

  2. #2
    Norman Jones
    Guest

    Re: Invoke exclusive excel process on opening this file

    Hi JB,

    Rather than seeking to use a separate instance of Excel, perhaps you could
    use the Workbook's Activate and Deactivate events.

    In the activate event, read and store the current values of any relevant
    Excel level settings and then change these to values appropriate to the
    workbook.

    In the Workbook's deactivate event, restore the relevant settings to the
    stored values.

    As a simple example, in the workbook's ThisWorbook module:

    Option Explicit
    Public CalcMode As Long

    '=======================>>
    Private Sub Workbook_Activate()

    CalcMode = Application.Calculation

    Application.Calculation = xlCalculationManual

    End Sub
    '<<=======================

    '=======================>
    Private Sub Workbook_Deactivate()

    Application.Calculation = CalcMode

    End Sub
    '<<=======================


    ---
    Regards,
    Norman



    "JB2005" <[email protected]> wrote in message
    news:[email protected]...
    > An excel workbook is required to start/use an exclusive Excel.exe process
    > whenever it is opened.
    >
    > This is to enable it to use specific tools/options settings which may
    > conflict with those already in use by other open files that may share an
    > existing process.
    >
    > eg. some workbooks will use "Auto calc.", others "Manual calc." options
    >
    > Any ideas?




+ 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