Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 22nd 04, 07:06 AM
Joseph Geretz
 
Posts: n/a
Default How do I isolate my Excel server (automation) from other Excel instances?

Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user then
hits X to exit their document (this is the normal user approach) this shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all toolbars.
I'm finding that now when the user opens their own documents, their favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!

- Joe Geretz -

P.S. How come there's no excel.vba group like there is for Word?



  #2   Report Post  
Old December 22nd 04, 08:12 AM
Frank Kabel
 
Posts: n/a
Default

Hi
only for your last question:
excel.programming

Though most regulars also read this .misc NG anyway

--
Regards
Frank Kabel
Frankfurt, Germany

Joseph Geretz wrote:
Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other
Excel documents, these documents all share the same Excel window. If
the user then hits X to exit their document (this is the normal user
approach) this shuts down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all
toolbars. I'm finding that now when the user opens their own
documents, their favorite toolbars are gone. Again, it's the same
basic issue. How do I isolate our own Excel server from other
instances of Excel in the user's environment?
Thanks for your help!

- Joe Geretz -

P.S. How come there's no excel.vba group like there is for Word?



  #3   Report Post  
Old December 22nd 04, 08:34 AM
Stephen Bullen
 
Posts: n/a
Default

Hi Joseph,

Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user then
hits X to exit their document (this is the normal user approach) this shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all toolbars.
I'm finding that now when the user opens their own documents, their favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!


To fix the underlying problem, you can set
Application.IgnoreRemoteRequests=True to make Windows start a new instance of
Excel when the user double-clicks an xls. You might also need/want to set
Application.Interactive=False. There's still the chance of someone getting your
instance of Excel if they double-click a workbook that's embedded in a Word
document (for example), which you might be able to avoid by starting *two*
instances of Excel (untested) - one for you to use, one to accept the COM
requests.

P.S. How come there's no excel.vba group like there is for Word?


Public.Excel.Programming fulfills that purpose for Excel.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk


  #4   Report Post  
Old December 22nd 04, 05:46 PM
Joseph Geretz
 
Posts: n/a
Default

Thanks guys!

excel.programming - I missed that one. See you there in the near future, I'm
sure!

- Joe Geretz -

"Stephen Bullen" wrote in message
...
Hi Joseph,

Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user
then
hits X to exit their document (this is the normal user approach) this
shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all
toolbars.
I'm finding that now when the user opens their own documents, their
favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!


To fix the underlying problem, you can set
Application.IgnoreRemoteRequests=True to make Windows start a new instance
of
Excel when the user double-clicks an xls. You might also need/want to set
Application.Interactive=False. There's still the chance of someone getting
your
instance of Excel if they double-click a workbook that's embedded in a
Word
document (for example), which you might be able to avoid by starting *two*
instances of Excel (untested) - one for you to use, one to accept the COM
requests.

P.S. How come there's no excel.vba group like there is for Word?


Public.Excel.Programming fulfills that purpose for Excel.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk




  #5   Report Post  
Old December 29th 04, 08:04 PM
 
Posts: n/a
Default

i've got a solution for you

get rid of excel and start using Access.

better yet, use Access Data Projects-- store the data in SQL Server; and
then you won't have to worry about Excel automation; since you can get to
the real data using real tools




"Joseph Geretz" wrote in message
...
Our application uses Excel as a server via the Excel COM interface
(automation). However, I'm finding that when the user opens other Excel
documents, these documents all share the same Excel window. If the user

then
hits X to exit their document (this is the normal user approach) this

shuts
down Excel altogether and my server is gone!

Also, our application streamlines the Excel window by removing all

toolbars.
I'm finding that now when the user opens their own documents, their

favorite
toolbars are gone. Again, it's the same basic issue. How do I isolate our
own Excel server from other instances of Excel in the user's environment?

Thanks for your help!

- Joe Geretz -

P.S. How come there's no excel.vba group like there is for Word?






  #6   Report Post  
Old July 19th 13, 03:18 PM
Junior Member
 
First recorded activity by ExcelBanter: Jul 2013
Posts: 1
Smile

Stephen.. These two VBA commands have made a world of difference in my automation processes.

THANKS!!!


Application.IgnoreRemoteRequests=True
Application.Interactive=False

line codes from Stephen Bullen; Microsoft MVP - Excel


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Automation SelectionChange event cpotts Excel Discussion (Misc queries) 1 December 20th 04 05:15 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 06:36 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017